Reputation: 1103
Is it possible to get the total without returning it in multiple rows (Group BY)?
Example:
Data:
ID Amount Quantity
1 50 1
2 50 2
select sum(Amount) * Quantity, SUM(Quantity) as totalQuantity
from tbl
I want the results to be in 1 row:
total totalQuantity
150 3
Upvotes: 6
Views: 13781