SELECT ... NEXT ??

P

PW

I am writing an ASP application which sits on top of an Access database
which contains a table with over 100K records.

I need to display approx 10 records at a time. Therefore I dont want to
"select * from table" and then page, as the initial "select" statement will
be very slow to perform.

Is there such a thing as "SELECT NEXT 10 * FROM TABLE" or something similar,
where I can just retrieve the initial 10 records, and subsequently fetch the
next 10 when the user clicks a "next" button?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select next 10 rows ? 1
Query problems 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
SELECT TOP Query in a Form 3
Random Select 2
Multiple selection 10
Problems creating unique records in a table 1
Next record 3

Top