I want to retrieve row number X to row Y

[Nicolasb]

Hi!

My query: SELECT * FROM table
Return 100 rows

I want to retrieve records from row number 20 to
row number 30...

How can I do this?

Thank you very much,
Nicolas

 

[Andel]

Hi, try this...

SELECT TOP 10 * FROM table
WHERE fieldid NOT IN
(SELECT TOP 20 fieldid FROM table)


Note: Replace the fieldid with a unique field.

Andel