Calculations in queries - How?
From: C. Lo <starshipdb_at_hotmail.com>
Date: 20 Mar 2004 11:42:55 -0800
Message-ID: <713a6263.0403201142.311ac391_at_posting.google.com>
Date: 20 Mar 2004 11:42:55 -0800
Message-ID: <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:
or more complicated:
SELECT (A+B) as sum
FROm Table
SELECT (C.number-(select count(*) from A)-(select count(*) from B)) AS
diff
FROM C
Thanks
Received on Sat Mar 20 2004 - 20:42:55 CET