Hi

I have a pervasive.sql database, and i want to select, using the sql command
only a seeral rows, lets say i want to take the 25# - 30# rows, how can i do that ?

What i found is the command TOP but its not good because its always starts
from the beginning, and i want to take lets say from the middle, from the x row to the y row.

Can i do that ?

Thanks.

You might be able to take the top 30 rows within a subquery, sort the results in DESC order, then select the top 5 from the subquery & finally sort THAT in descending order again... (to get the results you need)