Re: [SQL] Need to subtract values between previous and current row

06 > > Now I need a query that will subtract atime of row 1 from row 2, row2 from > row3 and so on... just an idea. select (A.atime - max(B.atime)) duration from table A join table B on (A.atime > B.atime) group by A.atime; Regards, Richard Broersma Jr. --

[SQL] Need to subtract values between previous and current row

row3 and so on... Can anyone please help? Regards. -- -- Partha Guha Roy *** Take everything you like seriously, except yourselves. - Rudyard Kipling