query in sql database

Question

How do we find the top 2 most populated cities i.e where no. of customers are higher than any other

Ian Henry · Accepted Answer · 2010-10-11 01:14:26Z

3

Assuming your schema looks like:

Customers
  -City
  -SSN

You should be able to simply use limit:

select City, count(SSN)
from Customers
group by City
order by count(SSN) desc
limit 2

answered Oct 11, 2010 at 1:14

Ian Henry

22.4k4 gold badges53 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If you want to restrict the results in some way further, then yes. But this is sufficient for the question you asked.