学步园

总结分页SQL语句为：

select top pageSize userID,name,country from info where userID not in
(select top pageSize*(curPage - 1) userID from info where country='morocco' order by userID Desc)
and country='morocco' order by userID Desc

-- 以ASC排序方式，从第5条开始，截取5行<br /> SELECT TOP 5 * FROM<br /> ( SELECT TOP 5 * FROM<br /> ( SELECT TOP 10 [ID],[NameText],[Title] FROM [Menu] AS TB__1 WHERE [Type]=0 ORDER BY [ID] ) AS TB__2<br /> ORDER BY [ID]) AS TB__3<br /> ORDER BY [ID] DESC

该分页查询方式必须依赖唯一键！！！