medium10 pts · first answer countswindow-functionssql

A window inside a window

An analyst writes AVG(ROW_NUMBER() OVER (ORDER BY ts)) OVER (). What happens?

A.It returns the average row number on every row directlyB.It runs, but silently ignores the inner ORDER BY clauseC.It runs, but returns NULL on every row of the resultD.It errors; compute the inner window in a subquery first

Discussion 0

Join free to post in the discussion.

A window inside a window

Discussion 0

Related questions