찾으면 안보이길래 남긴다 .출처 :&nbsp;<a href="http://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx" target="_blank" class="tx-link">http://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx</a> <a href="http://www.motolies.tistory.com/262" target="_blank">2013/03/08 - [프로그램 자료/MS-SQL] - MSSQL 순번 출력, 그룹순번출력 row , row_number</a> declare @curPage intdeclare @rowCount intset @curPage =&nbsp;1set @rowCount = 10&nbsp;&nbsp;select * from (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select ROW_NUMBER() OVER(ORDER BY WORD) AS ROW_NUM, WORD, CNT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from TestTable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where 1=1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and
YYMM = '2015-04'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and
CNT &gt; 10) as a



























where ROW_NUM BETWEEN ((@curPage - 1) * @rowCount + 1) AND (@curPage * @rowCount)

[MS-SQL 2008 or 2012] 페이징 쿼리 Paging Query