Returning the 20th - 30th records in a query result without using a unique index
Posted on 2005-04-14
Hello, Thanks for looking at my question.
I'm trying to come up with a good paging solution. So far my idea is to take the total number of rows, dived that by the number of rows that will be displayed on each page, and then send the start and end places to a stored procedure so the correct rows will be returned.
If I was returning all the rows and ordering by the id column, or unique incremental index, then it would be simple. But the results, ordered the way I need them could have the index row looking like
I'd like to just say, return rows 10 thru 20 of that results set, and it doesn't matter what the photographer_id is.
Is there any functionality in SQL/SQL Server 2000 that will allow me to do that?
Thank you for you time.