Recent Posts

Caution: Greetings to all visitors. The site is working in short. Links Please skip the link to view any topic and thank you for visiting
header ads

Group rows with highest values

Hello. I can't find any solution to my problem. This is my table:
ID ZONE COUNT
0 A 6
1 A 10
2 A 10
3 B 3
4 B 2
5 B 3

I need to select and group only rows with the highest values in their zones.
Expected result:
ID ZONE COUNT
1 A 10
2 A 10
3 B 3
5 B 3
I would really appreciate it if someone can help me. I...

Group rows with highest values

from MySQL https://ift.tt/2TTX0Jg
via IFTTT

Post a Comment

0 Comments