【每日一练：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 in