일반적인 페이징 쿼리 > db

SELECT TOP @PageSize * FROM titles
WHERE title_id NOT IN
     (SELECT TOP (@iPage * @PageSize) title_id FROM titles
      ORDER BY title_id ASC)
ORDER BY title_id ASC

---------------------------------------------------------------------------------------

PageSize = 10
ListSize = 20
CurrentPage = 1

SELECT * FROM (
    SELECT TOP [ListSize] * FROM (
        SELECT   TOP [CurrentPage * ListSize] [필드1], [필드2], [필드3]
        FROM  [테이블명]
        WHERE  [조건]
        ORDER BY [필드1], [필드2] ) A
    ORDER BY [필드1] DESC, [필드2] DESC) B
ORDER BY [필드1], [필드2]