Skills101
← All practice quizzes

Quiz: Window Functions

5 questionsNo time limitPass: 60%+10 XP on first pass

Rank rows, find the Nth highest salary per department, compare with the previous row and compute running totals — without collapsing rows like GROUP BY does.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    Salaries 100, 90, 90, 80 ordered DESC. What RANK does 80 get?

  2. Question 2

    Same salaries. What DENSE_RANK does 80 get?

  3. Question 3

    What does PARTITION BY do inside OVER()?

  4. Question 4

    Which function returns the value from the previous row?

  5. Question 5

    Why can't you write WHERE ROW_NUMBER() OVER (...) = 1?