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;Discussion 0
Join free to post in the discussion.