Level 4 - Mid-LevelOutput Prediction Questions
Output: Dense Rank with Salary Ties
What dense_rank does employee Cara get? SELECT name, salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS dr FROM employees;
What dense_rank does employee Cara get? SELECT name, salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS dr FROM employees;