[SQL] Grouping by day, limiting amounts

[Mezei Zoltán]

Hi, I didn't really know what subject I should give. I have a table like this one: 2006.10.01.    Bela    10 2006.10.01.    Aladar    9 2006.10.01.    Cecil    8 2006.10.01.    Dezso    7 2006.10.01.    Elemer    6 2006.10.02.    Bela    11 2006.10.02.    Aladar    10 2006.10.02.    Cecil    9 2006.10.02.    Dezso    8 2006.10.02.    Ferenc    7 2006.10.03.    Bela    6 2006.10.03.    Aladar    5 2006.10.03.    Cecil    4 2006.10.03.    Dezso    3 2006.10.03.    Jozef    2 The first column is a date, the second is a name, the third is the number of votes that the name received on that day. I would like to select the 3 (or 10) names with the most votes for each day. Any suggestions on how can it be done easily? Thanks, Zizi