查询分页的SQL实现

SELECT TOP 10 userinfo.user_name,Plan_Date,Plan_Week,Plan_Week_Day,Plan_Week_Text
FROM    Week_Plan INNER JOIN UserInfo ON userinfo.userID = Week_Plan.UserID
WHERE Plan_Month = '200511'
 and Plan_Date
not in (select top 2 Plan_Date from Week_Plan INNER JOIN UserInfo ON userinfo.userID = Week_Plan.UserID
WHERE Plan_Month = '200511'
ORDER BY userinfo.userID,plan_date) ORDER BY userinfo.userID,plan_date
第一个Top 10 是每页显示的条目数
第二个Top 2 是从第2+1=3条开始显示
对于每页显示10条信息来说，第二个Top m＝(n-1)*10，n为前端的页数

比如，每页显示10条，显示第3页：
m=(3-1)*10
SELECT TOP 10 字段名
FROM 表名
WHERE 条件
NOT IN (SELECT TOP m 同前条件)
ORDER BY 排序条件