Analytic question - lead

[saragosti]

Hi there,
I'm trying to write a function to select a series of events in one location, and tell me the time between these events. Lead has worked well thus far for this, however, I also want it to stop on certain events. Is there a way to tell it for example if it's been more than an hour, to not use the previous or next event?

Thanks,
Eric

 

[SantaMufasa]

Yes, Eric, you can do this, but to illustrate how, please post appropriate CREATE TABLE and INSERT INTO statements for us.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.