数据库查询分页

Oracle分页：

select b.* from

(select a.* ,rownum rnum from (select * from bi_indexmlk) a where rownum<=5)

b where rnum>=3

sql server分页：

--显示第3个至第5个入学的学生信息
select top 3 * from student where sname not in
(select top 2 sname from student order by entertime )
order by entertime

MySQL分页：

Select * from 表名 limit startrow,pagesize

(Pagesize为每页显示的记录条数)