Group rows with highest values

Discussion in 'MySQL' started by Cofyka, Jan 24, 2020.

0
  1. #1
    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 literally don't know where to start.
     
    Cofyka, Jan 24, 2020 IP