Search Postgresql Archives

oracle rank() over partition by queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: oracle rank() over partition by queries
From: "sharmi Joe" <sha.question@xxxxxxxxx>
Date: Tue, 11 Sep 2007 12:54:54 -0400

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: oracle rank() over partition by queries
  - From: Markus Schiltknecht
- Re: oracle rank() over partition by queries
  - From: Rodrigo De León

Prev by Date: Re: Sthange things happen: SkyTools pgbouncer is NOT a balancer
Next by Date: Re: Question about a query with two count fields
Previous by thread: Sthange things happen: SkyTools pgbouncer is NOT a balancer
Next by thread: Re: oracle rank() over partition by queries
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux