Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Returning rows based on Row Numbers in a Query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-22 : 21:54:20
Keith writes "Hi guys:

Was just reading the answer to the query 'Returning a Row Number in a Query' and the answer that didn't involve a temp table works just great for me. One thing I was wondering is how the query could be modified to return just the row numbers I want possibly using a 'rownumber BETWEEN 10 AND 20) all in the same query.
Can anyone help ???"
   

- Advertisement -