Question

oracle数据库sql怎么查询第5到第8条数据？

Answer 1

1、创建测试表，

create table test_row(id number , value varchar2(20));

2、插入测试数据

insert into test_row select 20+level as id, 'value_'||level from dual connect by level<=30;

commit;

3、查询表中全量数据，select t.* from test_row t;

4、编写sql，根据ID进行排序，查询第5条数据到8条数据；

   select * from (select t.*, row_number() over(order by id) rn from test_row t ) 

    where rn >= 5 and rn <= 8;