Skip to content
RED SAGSkills
easy5 pts · first answer countswindow-functionssql

Reusing a window alias

Why does this fail in most databases?

SELECT amount,
       SUM(amount) OVER () AS total,
       amount / total AS share
FROM sales;
Choose one answer

Discussion 0

Join free to post in the discussion.

Related questions