Plz help me to write this Sql Query?

AJAY

New member
Table Name: ABC
Table Data gitve gelow:

Name City
Raju Delhi
Ramesh Delhi
Amit Punjab
Sonu Delhi
Sumit Gurgaon
Kapil Delhi

First i want to count city and then from Count(city) result only select highest number of city with name.
 
Back
Top