Hi Manoj,
Again thanks a lot for your help!
Regards,
Jonny
[EMAIL PROTECTED] wrote:
i/p data
---------
table : x_test
s_sum timestamp
2150 7/26/02 1:13:47 AM
2162 7/26/02 1:15:01 AM
2170 7/26/02 1:16:27 AM
2200 7/26/02 1:20:34 AM
Solution :
------------
select a.s_sum - b.s_sum s_sum,a.timestamp
from x_test a,x_test b
where (a.s_sum > b.s_sum)
and b.s_sum =
(
select max(s_sum)
from x_test
where s_sum < a.s_sum
)
or rownum = 1
o/p data :
------------
s_sum timestamp
0 7/26/02 1:13:47 AM
12 7/26/02 1:15:01 AM
8 7/26/02 1:16:27 AM
30 7/26/02 1:20:34 AM
-----Original Message-----
From: jonny99delmont [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 7:13 PM
To: ORACLE-L
Cc: jonny99delmont
Subject: Substraction SQL query
<< File: Substraction SQL query.HTM >>
!
!
Get a bigger mailbox -- choose a size that fits your needs.
http://uk.docs.yahoo.com/mail_storage.html