b=1000指的是什么 分页一般用到两种办法: 1,利用rownum 2,分析函数row_number()over()1.select from( select t.*,rownum rn from( select * from a order by col1)t where rn between 101 and 200) 2. select * from(select t.*,row_number()over(order by col1)rn from t) where rn between 101 and 200
分页一般用到两种办法:
1,利用rownum
2,分析函数row_number()over()1.select from(
select t.*,rownum rn from(
select * from a
order by col1)t
where rn between 101 and 200)
2.
select *
from(select t.*,row_number()over(order by col1)rn
from t)
where rn between 101 and 200
直接用序列ID或者有序索引分页就好了