Grouping by day, limiting amounts - Mailing list pgsql-sql

From Mezei Zoltán
Subject Grouping by day, limiting amounts
Date
Msg-id 453766DB.6000408@telefor.hu
Whole thread Raw
Responses Re: Grouping by day, limiting amounts
Re: Grouping by day, limiting amounts
List 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 by date:

Previous
From: Robert Treat
Date:
Subject: Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL
Next
From: "A. Kretschmer"
Date:
Subject: Re: Grouping by day, limiting amounts