hard20 pts · first answer countswindow-functionssql

Percent of total with LIMIT 10

A query computes sales / SUM(sales) OVER () and ends with ORDER BY sales DESC LIMIT 10. What total is each share based on?

A.Only the 10 rows that the query finally returnsB.The first 10 rows the engine happened to readC.The whole table, ignoring the WHERE filter tooD.All rows that passed WHERE, not just the 10 shown

Discussion 0

Join free to post in the discussion.

Percent of total with LIMIT 10

Discussion 0

Related questions