Decoding Window Functions in SQL
Below questions will be answered during the tomorrow's session.
1. What is the difference between Rank, Dense_Rank, and Row_Number?
2. Why does Rank skip the sequence?
3. Why cant window functions be used in the WHERE clause?
4. In which scenario/business use case will Rank, Dense_Rank, and Row_Number give the same output?
5. How do you find the nth highest salary using a window function?