I am having trouble translating the following simple MSSQL query into the equivalent Postgres form.
Aggregate functions seam the way to go, but I have not been able to reproduce the totals at the
end of the query (not on each individual row).
Original MSSQL Query:
select A.ProdID, A.Description, A. Qty, A.Price
from SoldItems as A
where A.ListID = 15
order by A.ProdID
compute count(A.ProdID),sum(A.Price),sum(A.Qty)
Appreciating any help in advance,
Manfred Koroschetz
mkoroschetz(at)rkmus(dot)com