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

Answer 1

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