Quiz: Window Functions, Relations, and Joins
Test your knowledge of window functions, relations, and joins.
We'll cover the following...
We'll cover the following...
Technical Quiz
1.
In PostgreSQL, array_agg(x) over (order by x rows between unbounded preceding and current row) is equivalent to which option?
A.
array_agg(order by x)
B.
array_agg(x) over(order by x)
C.
array_agg(x) over(group by x)
D.
array_agg(x) over (rows between current row and unbounded following)
1 / 10