On 9/11/07, sharmi Joe <sha.question@gmail.com> wrote:
> Hi,
> Is there a way to get the oracle's rank() over partition by queries in
> postgresql? For example if I have a query like
>
> Select Col1, Col2, RANK() OVER(PARTITION BY Col1 order by Col3 desc) as rank
> from table1
>
> Thanks in advance
See:
http://troels.arvin.dk/db/rdbms/#select-top-n