Re: oracle rank() over partition by queries

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "sharmi Joe" <sha(dot)question(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org(dot)
Subject: Re: oracle rank() over partition by queries
Date: 2007-09-11 17:03:11
Message-ID: a55915760709111003qe180601q84e3795a8e39f273@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/11/07, sharmi Joe <sha(dot)question(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Pavlov 2007-09-11 17:03:48 Re: Question about a query with two count fields
Previous Message Phoenix Kiula 2007-09-11 17:02:13 Re: Hardware recommendation: which is best