Select a particular set of records from MSACCESS table

I have 10 asp pages. I have an MSACCESS table with say some 300 records. I want to select last 10 records ie. rows 290-300 from the table and display it in the first asp page. Then, I want to select the rows 280-290 in the second asp page etc....The number of records in the table are not limited to 300, it keeps growing. I want a select query to take the last 10 records. I have an answer for that,
"select top 10 * from link order by id desc"
This query returns the latest 10 rows from the table, ie. rows 290-300
Now I want to select the rows 280-290. Is there any select query for that. Or can I achieve that is asp coding?

Any hep is appreciated
Thank you.
LVL 16
CWS (haripriya)Asked:
Who is Participating?
select top 10 * from link WHERE id <= 290 order by id desc
I think you need pagination script...

here is a complete solution for your problem...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.