SQL Window Function Ordering
What is the output of this query?
SELECT name, salary,
ROW_NUMBER() OVER (ORDER BY salary DESC) as rn
FROM employees
WHERE department = 'Sales';
Sign in to answer questions and track your progress
Sign InWhat is the output of this query?
SELECT name, salary,
ROW_NUMBER() OVER (ORDER BY salary DESC) as rn
FROM employees
WHERE department = 'Sales';
Sign in to answer questions and track your progress
Sign In