oracle rank() over partition by queries

From: "sharmi Joe" <sha(dot)question(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org(dot)
Subject: oracle rank() over partition by queries
Date: 2007-09-11 16:54:54
Message-ID: 790a1ed90709110954r91aa2ffg84f1e57e56ba04a6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Lanzarotta 2007-09-11 16:57:52 Re: Question about a query with two count fields
Previous Message Jeff Davis 2007-09-11 16:54:38 Re: Sthange things happen: SkyTools pgbouncer is NOT a balancer