mssql top처리 (중간의 데이타를 얻기위한 방법 )

SELECT TOP 

					

						[얻으려는 행의수] * 
FROM [TABLE]
 WHERE [PRIMARY KEY] NOT IN 
( 
          SELECT TOP [중간의 시작위치 - 1] [PRIMARY KEY] 
          FROM [TABLE] 
          WHERE [조건] 
          ORDER BY [PRIMARY KEY]
 )
 AND [조건] 
ORDER BY [PRIMARY KEY]

select top 20  * 
from  datatable
where idfield not in (select top 8 idfield from authors  order by idfield)
order by idfield