三大数据库分页方法（Oracle/MySQL/SQL）

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 student order 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)