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/