easy5 pts · first answer countswindow-functionssql

Sorting by a window value

Can a window function appear in the final ORDER BY clause, for example ORDER BY SUM(sales) OVER (PARTITION BY region) DESC?

A.No, window functions are only allowed in SELECTB.Only if the same window also appears in WHEREC.Only when the query also has a GROUP BY clauseD.Yes, ORDER BY runs after windows are computed

Discussion 0

Join free to post in the discussion.

Sorting by a window value

Discussion 0

Related questions