SELECT TOP 一页数量 [t_users].[uid]
FROM [t_users]
WHERE [t_users].[uid] < (
SELECT min([uid]) FROM (
SELECT TOP (页码 - 1) * 一页数量 [uid] FROM [t_users] WHERE 条件 ORDER BY [uid] DESC)
AS tblTmp )
AND 条件 ORDER BY [t_users].[uid] DESC
----------------------------------------------------------------------------------------------------------------
另一种实现方法:通过把需要分页显示的数据主键ID(新生成一个流水号顺序字段作为分页标识字段<sequencefield betwen startIndex in endIndex>)单独存到一个临时表中,然后将临时表left join 原始表来实现分页取数.