Dear all,

I was wondering : how do you limit the rows returned by a select statement depending on the row number ?

Let's say I want a control which returns the first (i.e. 0-20) 20 rows of a select statement. It's going to have a button which'll move onto the next 20 matches (say 20-40), and then again (40-60).

How would I go about doing this ? Can you specify in SQL the row numbers for a select statement to return ?

Of couse I could do this in client code : but if I want matches 1000-1020 then I don't want the code to have to iterate through 1000 rows before reaching the one which is to be displayed.

Thanks in advance,

Darwen.