展开全部

1、创建测试表，

create table test_sale(id varchar2(20),sale_num number(10));

2、插入测试数据；

insert into test_sale values('goods_1',15);

insert into test_sale values('goods_2',125);

insert into test_sale values('goods_3',28);

insert into test_sale values('goods_4',36);

insert into test_sale values('goods_5',72);

insert into test_sale values('goods_6',85);

insert into test_sale values('goods_7',99);

insert into test_sale values('goods_8',100);

insert into test_sale values('goods_9',102);

insert into test_sale values('goods_10',35);

commit;