【每日一练：SQL】oracle随机查询出10条数据

SQL题：
随机查询出10条数据

数据库版本：Oracle 11g解答：

--创建测试数据
create table tb_sales(year int,season int,sale int);

--插入数据
insert into tb_sales values(2017,1,11);
insert into tb_sales values(2017,2,12);
insert into tb_sales values(2017,3,13);
insert into tb_sales values(2017,4,14);
insert into tb_sales values(2018,1,21);
insert into tb_sales values(2018,2,22);
insert into tb_sales values(2018,3,23);
insert into tb_sales values(2018,4,24);

insert into tb_sales
select * from tb_sales;

commit;

--随机查询10条数据

select * from (
        select * from tb_sales
         order by dbms_random.random()
       )
 where rownum < 11;