SQL Advanced Quiz

Subqueries, window functions, CTEs, indexes, and advanced SQL techniques.

advanced

Question 1 of 7

Question 1 of 7sql

What does a window function use to define the working set of rows?

sql

SELECT name, salary,
  RANK() OVER (PARTITION BY dept ORDER BY salary DESC) AS rnk
FROM employees