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