oracle fetch分页
语法:
start_row:开始行数
row:分页的行数
select * from dual OFFSET start_row ROWS FETCH NEXT row ROWS ONLY;
使用:一般搭配order by 使用
select * from dual order by col asc OFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY;
语法:
start_row:开始行数
row:分页的行数
select * from dual OFFSET start_row ROWS FETCH NEXT row ROWS ONLY;
使用:一般搭配order by 使用
select * from dual order by col asc OFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY;