Expand|Select|Wrap|Line Numbers
- Select Sum(sellingprice-buyingprice)*quantity from orders where date = '2008/01/30'
when i change the statement to
Expand|Select|Wrap|Line Numbers
- Select Sum(sellingprice-buyingprice)*quantity from orders where date = '2008/01/30' GROUP BY sellingprice
i want the sum of the entire column
please HELP....