On 9/11/07, sharmi Joe <sha.question@xxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
