Postgres Pro
Downloads
Home   >   mailing lists

oracle rank() over partition by queries - Mailing list pgsql-general

From sharmi Joe
Subject oracle rank() over partition by queries
Date
Msg-id 790a1ed90709110954r91aa2ffg84f1e57e56ba04a6@mail.gmail.com
Whole thread Raw
Responses Re: oracle rank() over partition by queries
Re: oracle rank() over partition by queries
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Sthange things happen: SkyTools pgbouncer is NOT a balancer
Next
From: Jeff Lanzarotta
Date:
Subject: Re: Question about a query with two count fields