【每日一练：SQL】rowunm：查询表test第5-10条记录

oracle查询表第5-10条记录

SQL题目：
存在表tb_test0311(id,name)，要根据字段id排序后取第5-10条记录，请给出sql

解决：

数据库版本：Oracle 11g
--创建表和插入数据

create table tb_test0311(id int, name varchar2(30));

insert into tb_test0311 values(1,'111');
insert into tb_test0311 values(2,'222');
insert into tb_test0311 values(3,'333');
insert into tb_test0311 values(4,'444');
insert into tb_test0311 values(5,'555');
insert into tb_test0311 values(6,'666');
insert into tb_test0311 values(7,'777');
insert into tb_test0311 values(8,'888');
insert into tb_test0311 values(9,'999');
insert into tb_test0311 values(10,'101010');
insert into tb_test0311 values(11,'111111');
insert into tb_test0311 values(12,'121212');
insert into tb_test0311 values(13,'131313');
insert into tb_test0311 values(14,'141414');
insert into tb_test0311 values(15,'151515');
commit;

--SQL语句

select id, name
  from (
        select rownum rn, id, name
          from tb_test0311
         order by id
        )t
 where t.rn between 5 and 10;

ID	NAME
5	555
6	666
7	777
8	888
9	999
10	101010