Wednesday, 2 October 2013

Query to multiple each row's cost times quantity and sum

Query to multiple each row's cost times quantity and sum

I'm having a difficult time getting this to work. I have a table that
looks like this:
quantity cost
-------- ----
5 150
2 100
and I'd like to select a single result which should be 950. When I use
group by the entire quantities gets multiplied times the entire cost

No comments:

Post a Comment