Intermediate
Database Management Systems
Q64 / 100
What is a window function in SQL?
Correct! Well done.
Incorrect.
The correct answer is B) A function computing values across a set of rows related to the current row without collapsing them into one group, using OVER() clause
B
Correct Answer
A function computing values across a set of rows related to the current row without collapsing them into one group, using OVER() clause
Explanation
Window functions (ROW_NUMBER(), RANK(), LAG(), SUM() OVER()) perform calculations across related rows while returning individual rows. Essential for running totals, rankings, and lag/lead analysis.
Progress
64/100