User Tools

Site Tools


kurs:rank

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

kurs:rank [2014/09/10 21:22] (current)
Line 1: Line 1:
 +<​code>​ 
 +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; 
 +</​code>​
kurs/rank.txt · Last modified: 2014/09/10 21:22 (external edit)