Intermediate
SQL
Q72 / 100
What does the "LEAD()" / "LAG()" window functions do?
Correct! Well done.
Incorrect.
The correct answer is B) They access the value of a column in a subsequent (LEAD) or preceding (LAG) row within the result set, relative to the current row
B
Correct Answer
They access the value of a column in a subsequent (LEAD) or preceding (LAG) row within the result set, relative to the current row
Explanation
LAG() and LEAD() let you reference values from other rows (previous or next, respectively, based on the specified ordering) without using a self-join.
Progress
72/100