User Tools

Site Tools


kurs:rank
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;
kurs/rank.txt · Last modified: 2014/09/10 21:22 (external edit)