select emp_name, dept_id, salary, row_number() over(partition by dept_id order by salary desc), rank() over(partition by dept_id order by salary desc), dense_rank ...
rank of salary within the department (highest salary = rank 1) using only RANK(), nothing else. /* For each department, list employees whose salary rank is 1 or 2 using RANK(). For each department, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results