Re: Time difference between records
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 14 Sep 2004 18:21:55 +0200
Message-ID: <41471a02$0$20456$626a14ce_at_news.free.fr>
where diff is not null
/
Date: Tue, 14 Sep 2004 18:21:55 +0200
Message-ID: <41471a02$0$20456$626a14ce_at_news.free.fr>
"Scott Johnson" <stj_spam_at_yahoo.com> a écrit dans le message de
news:414702d0$0$26167$bb8e7a08_at_news.usenetcompany.com...
> I need to find a method (sql, plsql) to find the time difference between
> records
>
> Example,
> Ticket# Operation Time
> A1 Modify 1000
> A1 Modify 1100
> A1 Modify 1300
> A2 Modify 0900
> A2 Modify 0930
>
> Should produce something like:
>
> A1 1 hour
> A1 2 hours
> A2 30 minutes
>
> Has anyone done this before?
>
>
Just a hint:
select ticket#, diff
from (select ticket#,
time-lag(time) over (partition by ticket# order by time) diff
from mytable)
where diff is not null
/
Btw, don't cross/multipost, we read all the cdo groups.
-- Regards Michel CadotReceived on Tue Sep 14 2004 - 18:21:55 CEST