Using top x statement could be another solution. For example, in pubs
sample database, you can select 6-10 using the following expression:
select top 5 * from (select top 10 * from authors order by au_lname) as t
order by au_lname desc
This posting is provided "AS IS" with no warranties, and confers no rights.