Oracle分页
"select * from (select gd.*,rownum rn from Good gd)where rn between "+start +" and "+end
rownum并不是用户添加的字段,而是oracle系统自动添加的。
select * from (select rownum recno, studentId, studentName from student order by studentId) where recno between 3 and 4
select * from (select rownum as r, t.* from (select * from studentorder by studentId desc) t where rownum<=1) where r>0
MySQL分页
SELECT * from myuser LIMIT pageIndex,pageSize
SQL分页
SELECT TOP(@pagesize) * FROM Table WHERE id NOT IN (SELECT TOP((@pageindex-1) * @pagesize)id FROM Table)
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。