medium10 pts · first answer countssqlwindow-functionsquery-order

ROW_NUMBER in a WHERE clause

This query fails with "window functions are not allowed in WHERE". What is the standard fix?

A.Move the ROW_NUMBER expression into GROUP BYB.Replace WHERE with HAVING and keep the rest of the queryC.Add DISTINCT so the window can run in WHERED.Compute ROW_NUMBER in a CTE, then filter it outside

Discussion 0

Join free to post in the discussion.

ROW_NUMBER in a WHERE clause

Discussion 0

Related questions