Re: [SQL] equivalent of oracle rank() in postgres

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Jus wanted the equivalent for rank() as in tis example.. > SELECT * > FROM ( > SELECT employee_id, last_name, salary, > RANK() OVER (ORDER BY salary DESC) EMPRANK > FROM employees) > WHERE emprank = 3; There is no direct equivalent to rank(

[SQL] equivalent of oracle rank() in postgres

  Hi,   Jus wanted the equivalent for rank() as in tis example..   SELECT * FROM (   SELECT employee_id, last_name, salary,   RANK() OVER (ORDER BY salary DESC) EMPRANK   FROM employees) WHERE emprank = 3;   Rgds, Chandan