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, ...
-- Both functions are window functions used to assign ranks to rows based on a specific order, such as salary, marks, score, etc. -- RANK() OVER (PARTITION BY column_name ORDER BY column_name DESC) -- ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results