[SQL] equivalent of oracle rank() in postgres

[Chandan_Kumaraiah]

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