Oracle allows to select pseudo-columns with a special meaning.
[sql]
SELECT *
FROM (
SELECT ROWNUM as rank, Emp_id, Emp_salary
FROM employees
ORDER BY Emp_salary
)
WHERE rank=3
;
[/sql]