Grouping by day, limiting amounts
От | Mezei Zoltán |
---|---|
Тема | Grouping by day, limiting amounts |
Дата | |
Msg-id | 453766DB.6000408@telefor.hu обсуждение исходный текст |
Ответы |
Re: Grouping by day, limiting amounts
Re: Grouping by day, limiting amounts |
Список | pgsql-sql |
<font size="-1"><font face="Tahoma">Hi,<br /><br /> I didn't really know what subject I should give.<br /><br /> I have atable like this one:<small><br /><br /></small></font></font><small><font face="Tahoma">2006.10.01. Bela 10<br />2006.10.01. Aladar 9<br /> 2006.10.01. Cecil 8<br /> 2006.10.01. Dezso 7<br /> 2006.10.01. Elemer 6<br /> 2006.10.02. Bela 11<br /> 2006.10.02. Aladar 10<br /> 2006.10.02. Cecil 9<br /> 2006.10.02. Dezso 8<br /> 2006.10.02. Ferenc 7<br /> 2006.10.03. Bela 6<br /> 2006.10.03. Aladar 5<br/> 2006.10.03. Cecil 4<br /> 2006.10.03. Dezso 3<br /> 2006.10.03. Jozef 2<br /><br /> The first columnis a date, the second is a name, the third is the number of votes that the name received on that day.<br /><br /> Iwould like to select the 3 (or 10) names with the most votes for each day.<br /><br /> Any suggestions on how can it bedone easily?<br /><br /> Thanks,<br /><br /> Zizi<br /></font></small>
В списке pgsql-sql по дате отправления: