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

Every share shows 0

In PostgreSQL, qty is an integer column. Every row shows share = 0. Why?

SELECT product, qty,
       qty / SUM(qty) OVER () AS share
FROM stock;
Choose one answer

Discussion 0

Join free to post in the discussion.

Related questions