Question

在SQL中怎样查询一个表的第20条数据到30条数据

Answer 1

1、创建测试表，

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

2、插入测试数据

insert into test_order select 100+level as id, 'value_'||level from dual connect by level<=100;

commit;

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

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

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

    where rn >= 20 and rn <= 30;