dokuwiki

This is an old revision of the document!

---

SELECT *
FROM (
   SELECT employee_id, last_name, salary,
   RANK() OVER (ORDER BY salary DESC) EMPRANK
   FROM employees)
where    emprank > 10 and emprank < 13
-- WHERE emprank = 2;