
SQL Programming
May 31, 2025 at 09:40 AM
Consider the following employee salaries (sorted descending):
Emp | Salary
A | 5000
B | 5000
C | 4000
D | 3000
If we use:
SELECT RANK() OVER (ORDER BY salary DESC) AS rnk
What is the rank of Employee C?
👍
❤️
❤
💩
😮
🙏
19