Hi,
How can i get number of records available city wise using sql query.
ex: DB structure and data:
ID Name City
1 A CHN
2 B MUM
3 C DEL
4 D CHN
5 E CHN
6 F MUM
7 G DEL
8 H DEL
9 I DEL
10 J MUM
RESULT SHOULD BE
CITY Records
CHN 3
MUM 3
DEL 4
Can any one help me in this regard.
regards,
Thiru