Selecting consecutive rows

2003-09-12 Thread Robert Kilroy
Greetings, I've been trying to work out a query for this project and I'm finally at the end of my rope. Basically, I have a ticket sales app. There is a table that has row_num and seat_num and seat_status. What I need to do is retrieve X number of seats that are sequential. For example, if

Re: Selecting consecutive rows

2003-09-12 Thread Roger Baklund
* Robert Kilroy I've been trying to work out a query for this project and I'm finally at the end of my rope. Basically, I have a ticket sales app. There is a table that has row_num and seat_num and seat_status. What I need to do is retrieve X number of seats that are sequential. For example,

Re: Selecting consecutive rows

2003-09-12 Thread Bruce Feist
Robert Kilroy wrote: I've been trying to work out a query for this project and I'm finally at the end of my rope. Basically, I have a ticket sales app. There is a table that has row_num and seat_num and seat_status. If you have the luxury of being able to change this, consider replacing it with