[MS-SQL] 게시판 페이징 SQL

SELECT [sid], [content] FROM (

           SELECT

                     ROW_NUMBER() OVER(ORDER BY [sid] DESC) AS [rownum],[sid],[content]

           FROM loadTest

) AS subrow WHERE subrow.[rownum] BETWEEN 100001 AND 100020


출처 : http://innoc99.blog.me/140072364578