[MsSql] Common Table Expression (CTE) 페이징 처리

WITH Members AS 

( 
SELECT 
M_NAME, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_COUNTRY, ROW_NUMBER() OVER (ORDER BY M_POSTS DESC) AS RowNumber 
FROM dbo.FORUM_MEMBERS 
) 
SELECT 
RowNumber, M_NAME, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_COUNTRY 
FROM Members 
WHERE RowNumber BETWEEN 1 AND 20 
ORDER BY RowNumber ASC;
 
출처 : http://www.sqlteam.com/article/server-side-paging-using-sql-server-2005