is there any sql statement for ...

hi,

i want to select between 100th and 200th records on a table.
is there any sql statement for that like TOP statement.

I know TOP statement returns absultely (or percently when use TOP
PERCENT) top records. But i need between 100th and 200th records or other.

if there is not, is there any way for that?

If you have an auto incrementing index you could use it in your SQL
statement.

Where ID > 99 and ID < 201.

"Zeynel Kaya" wrote in message

> hi,
>
> i want to select between 100th and 200th records on a table.
> is there any sql statement for that like TOP statement.
>
> I know TOP statement returns absultely (or percently when use TOP PERCENT)
> top records. But i need between 100th and 200th records or other.
>
> if there is not, is there any way for that?