oralce 分页查询
select b.* from (
select t.*,ROWNUM as rn from t_empe t
)
b where b.rn>(页数-1)*行数 and b.rn<=页数*行数;
select b.* from
(select t.*,rownum r from t_emp1 t)b
where b.r> (2-1)*4 and b.r <=2*4
(select t.*,rownum r from t_emp1 t)b
where b.r> (2-1)*4 and b.r <=2*4