oracle 分页
[5-20]
方法1:
select * from (
select t.*,rownum rn from table t rownum<=20
) where rn>=5;
方法2:
select * from(
select t.* rownum rn from table t
) where rn>=5 and rn<=20
java封装分页
get String getsql(String sql,int start,int size){
select rownum rn,* from ${sql} where rn<start+size and rn>=start;
}
取出前十名
select * form (slect * ,rank over(order by score desc) rank_num from table ) where rank_num<=10;