Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2008-12-06 : 22:57:16
|
| I want to write a select statement using arithmetic operator minus., getting the leftoveramount.select sum(invoice_amt) - sum(order_Amt) as leftoveramount from table_ordersThank you very much. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-07 : 00:57:27
|
| this looks fine. are you getting any error? |
 |
|
|
|
|
|
Select query how to use arithmetic operator minus