Обсуждение: oracle rank() over partition by queries

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

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

Hello Sharmi Joe,

sharmi Joe wrote:
> Is there a way to get the oracle's rank() over partition by queries in
> postgresql?

These are known as window functions. AFAIK Gavin Sherry is working on an
implementation for Postgres.

Regards

Markus

Thanks Markus

Markus Schiltknecht <markus@bluegap.ch> wrote:

Hello Sharmi Joe,

sharmi Joe wrote:
> Is there a way to get the oracle's rank() over partition by queries in
> postgresql?

These are known as window functions. AFAIK Gavin Sherry is working on an
implementation for Postgres.

Regards

Markus

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

---

Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.