RE: sql query on substract

From: Jonny Delmont <jonny99delmont_at_yahoo.co.uk>
Date: Fri, 26 Jul 2002 03:43:24 -0800
Message-ID: <F001.004A32C4.20020726034324@fatcity.com>

 Larry and Manoj, Thanks a lot! this solved my problem. Regards,
Jonny
  cosltemp-g.manoj_at_orbitech.co.in wrote: data

---

s_month s_sum

JAN 1000
FEB 1200
MAR 1250
APR 2000 query

---

select b.s_month b_mth,s_sum - a.amt
from x_test b,
(

select s_month,s_sum amt
from x_test
) a
where (b.s_month = a.s_month and
(b.s_month = 'JAN'))

or
(b.s_month = to_char(add_months(to_date(a.s_month,'MON'),1),'MON'))
order by to_date(b.s_month,'MON')

output

---

JAN 0
FEB 200
MAR 50
APR 750 -----Original Message-----
Sent: Friday, July 26, 2002 3:13 PM
To: ORACLE-L
Cc: jonny99delmont

<< File: sql query on substract.HTM >>

---

Get a bigger mailbox -- choose a size that fits your needs.

http://uk.docs.yahoo.com/mail_storage.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Jonny=20Delmont?=
  INET: jonny99delmont_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Fri Jul 26 2002 - 06:43:24 CDT