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

SELECT TOP [fusion_builder_container hundred_percent="yes" overflow="visible"][fusion_builder_row][fusion_builder_column type="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" spacing="yes" background_image="" background_repeat="no-repeat" padding="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="no" center_content="no" min_height="none"][얻으려는 행의수] * 
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 [fusion_builder_container hundred_percent="yes" overflow="visible"][fusion_builder_row][fusion_builder_column type="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" spacing="yes" background_image="" background_repeat="no-repeat" padding="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="no" center_content="no" min_height="none"][얻으려는 행의수] *

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

select top 20 *

from datatable

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

order by idfield

[/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

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

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

Leaqua