Quiz: Window Functions, Relations, and Joins
Test your knowledge of window functions, relations, and joins.
We'll cover the following...
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)
Question 1 of 100 attempted
Access this course and 1400+ top-rated courses and projects.