I have a test table which looks like:
And I want to find the city with the max population.
Here is my query:
SELECT City, count(*) AS [Population]
GROUP BY City
SELECT City, [Population]
WHERE [Population] =
DROP TABLE #stats
Is it possible to do it in one query, without using a temp table?
What would other shorter practical ways be to get that result?