[SQL] Comparing sequential rows in a result

2008-10-29 Thread Murray Long
I'm relatively new to SQL, and am frequently running into the same problem, How do I compare different rows in a result? for example: If I have a table of events consisting of a time stamp and the event type: timestamp, event_type 12:00 a 12:10 b 12:20

Re: [SQL] Comparing sequential rows in a result

2008-10-29 Thread Murray Long
l = ttab.nextval+1; This works, but seems a very messy way to accomplish somehting quite simple. On Wed, Oct 29, 2008 at 11:01 AM, Murray Long <[EMAIL PROTECTED]> wrote: > I'm relatively new to SQL, and am frequently running into the same problem, > How do I compare different