Thread: 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
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:
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.
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.