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(userId) FROM (SELECT TOP $start$ userId FROM t_user
------解决方案--------------------------------------------------------
可参考:
MS SQL分页有关问题   http://www.myexception.cn/sql-server/297915.html

另这里的部分程序错误异常BUG解决方案

%D%A

java环境变量设置|http://www.myexception.cn/java-other/172921.html

%D%A

oracle存储过程|http://www.myexception.cn/oracle-develop/177537.html

Shark, OSWorkflow跟jBPM ,选哪个