Re: [SQL] how do i get differences between rows

2003-12-24 Thread teknokrat
Bruno Wolff III wrote: On Thu, Dec 18, 2003 at 12:21:35 +, teknokrat <[EMAIL PROTECTED]> wrote: I am after an sql query that can give the differnces between consecutive timestamp values in the resultset. anyone know how to do this? I think you can do something like the following (untested)

Re: [SQL] how do i get differences between rows

2003-12-23 Thread Bruno Wolff III
On Thu, Dec 18, 2003 at 12:21:35 +, teknokrat <[EMAIL PROTECTED]> wrote: > I am after an sql query that can give the differnces between consecutive > timestamp values in the resultset. > anyone know how to do this? I think you can do something like the following (untested) on most systems. s