General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL SELECT - How to do a Fast Internet style query?
Consider a SQL Server table sitting on a Website with say 1,000,000 records. The user on the internet wants to be able to see the first 100 records (sorted by ProductID), then click "Next" and see the next 100 and ... so on.
How to I write a query to retrieve the nth set of these records.
ie the query should retrieve the 100*(n-1) to 100*n set of records in the order of field ProductID when the user clicks "Next" for the nth time.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only