t-sql:分页查询常见写法

SQL分页查询：

最佳方案：
SELECT TOP 10 *
FROM t_works
WHERE workId >
          (
          SELECT ISNULL(MAX(workId),0)
          FROM
                (
                SELECT TOP 59 workId FROM t_works ORDER BY workId
                ) t_works
          )
ORDER BY workId；

较好方案：
select top 10 *
FROM t_works
WHERE workId NOT IN
          (
          SELECT TOP 30 workId FROM t_works ORDER BY workId
          )
ORDER BY workId

最常见方案：
SELECT TOP 10 workId,enabled,state,parentId,warning,workType,sourceType,doWay,returnType,resultType,dept,operator,localTel,callTel,
 exCallTel,callName,address,regTime,waitTime,acceptTime,begTime,endTime,warnTime,finishTime,remark,soundFile,modTime
FROM
        (
        SELECT ROW_NUMBER() OVER (ORDER BY workId) AS RowNumber,* FROM t_works
        ) A
WHERE RowNumber > 10*(4-1)；