페이지 쿼리

 

 

DECLARE @PageNumber AS INT
,  @RowsPage AS INT

SET @PageNumber = 3
SET @RowsPage = 5

SELECT *
FROM TABLE_NAME
ORDER BY COLUMN_Name ASC
OFFSET((@PageNumber - 1) * @RowsPage) ROWS
FETCH NEXT @RowsPage ROWS ONLY

 

 

관련 URL http://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx