全部博文
-
编辑 删除
求个ms sql分页查询解决方法
select top 2 * from tablename where uid>(select max(uid) from(select top(2*1) uid from tablename order by uid) a)order by uid 搞不懂MSSQL的分页，1页2条，要查第1页怎么查询？ 解决了SELECT TOP ${pagesize} * FROM tablenameWHERE uID >= (SELECT MAX(uid) FROM (SELECT TOP (${pagesize}*(${pageno}-1)+1) uid FROM tablename --写查询条件 ORDER BY uid) AS T) ------解决方案-------------------------------------------------------- SELECT TOP $limit$ * FROM t_user WHERE (userId >= (SELECT MAX(u
