easy5 pts · first answer countswindow-functionssql

ORDER BY inside and outside OVER

A query uses ROW_NUMBER() OVER (ORDER BY sales DESC) but has no ORDER BY at the end. What is true about the output order?

A.Rows always come out sorted by sales DESCB.Rows always come out in rn orderC.The output order is not guaranteedD.Rows come out in insert order

Discussion 0

Join free to post in the discussion.