SELECT ProdID, SUM(qty) AS SubTotal, (SELECT SUM(qty) FROM OrderItem) AS Total
FROM OrderItem
GROUP BY ProdID
ORDER BY SubTotal DESC
i to mi daje nesto kao ovo:
ProdID SubTotal Total
15 10000 100000
6 8000 100000
9 6000 100000
meni bi trebalo da mi vraca procentualan udeo SubTotal u Total, i pokusao sam to ovako:
SELECT ProdID, SUM(qty) AS SubTotal, (SELECT SUM(qty) FROM OrderItem) AS Total, [b]SubTotal / Total * 100 AS Percentage[/b]
FROM OrderItem
GROUP BY ProdID
ORDER BY SubTotal DESC
ali mi SQL Server daje gresku: Invalid column name 'SubTotal'
U cemu je problem? MS SQL? (Cini mi se da je to MySQL server gutao)