PageSize //页大小
CurrentPage //当前页
1. SqlServer2000
SELECT
TOP PageSize *
FROM
T_User a
WHERE
a.F_ID NOT IN
(SELECT TOP (CurrentPage-1)*PageSize F_ID FROM T_User ORDER BY F_ID))
ORDER BY F_ID

被折叠的 条评论
为什么被折叠?