On 9/11/07, sharmi Joe <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
