Level 3 - IntermediateOutput Prediction Questions
Output: Rank with Ties
For employee Ben, what rank value is returned? SELECT name, salary, RANK() OVER (ORDER BY salary DESC) AS rnk FROM employees;
For employee Ben, what rank value is returned? SELECT name, salary, RANK() OVER (ORDER BY salary DESC) AS rnk FROM employees;