Re: Calculations in queries - How?
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sat, 20 Mar 2004 17:43:04 -0500
Message-ID: <xLudnQnPvf-OVMHdRVn-sA_at_comcast.com>
Date: Sat, 20 Mar 2004 17:43:04 -0500
Message-ID: <xLudnQnPvf-OVMHdRVn-sA_at_comcast.com>
"C. Lo" <starshipdb_at_hotmail.com> wrote in message
news:713a6263.0403201142.311ac391_at_posting.google.com...
| Hi
|
| I'm wondering if there is a way of having a query return a calculation
| of multiple attributes
|
| ie - something like:
| SELECT (A+B) as sum
| FROm Table
|
| or more complicated:
| SELECT (C.number-(select count(*) from A)-(select count(*) from B)) AS
| diff
| FROM C
|
| Thanks
yes
go to http://tahiti.oracle.com
download the SQL reference manual, read about expressions, functions, subqueries
;-{ mcs Received on Sat Mar 20 2004 - 23:43:04 CET