Hi,

i have the table like this,

+------+-------+-----+
| city | caste | cnt |
+------+-------+-----+
| 1 | 1 | 2 |
| 1 | 2 | 3 |
| 2 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 1 | 3 |
| 3 | 3 | 1 |
+------+-------+-----+



i want to select the top caste which is having the most cnt value for the each city.


expecting output

+------+-------+-----+
| city | caste | cnt |
+------+-------+-----+
| 1 | 2 | 3 |
| 2 | 2 | 2 |
| 3 | 1 | 3 |
+------+-------+-----+

Can you any one help me...?

Thanks,
S.Ashokkumar.

What have you tried so far?

hi...

in ur result which is caste and which is count.....