Re: How do you select from a table until a condition is met?

On Wed, Feb 12, 2003 at 20:10:15 +0100,
Nicholas Allen <nallen(at)freenet(dot)co(dot)uk> wrote:
>
> Thanks, but I don't think thats what I want. Basically I need to get the row
> offset of a record (ie row) in a result set returned from the database. I
> know all the details of the row in question but when the search order changes
> I need to know the new index the row will have.
>
> In other words, I was hoping I would be able to select upto a particular row
> (not knowing its offset but knowing everything else about it) in a select
> query.
>
> Ideally I could do something like SELECT count(*) UNTIL col1=value1 &&
> col2=val2 etc....

Since you are ordering the data you can use where clauses with < (and/or >)
operators to stop counting at the desired row. For this to work the ordering
needs to be well defined. You can tack on the primary key to your list
of columns to order by to make the ordering well defined if it isn't
already.