sql计算当前年较上一年的销售量的增长率(当年的一道sql笔试题)

Rocky19890818

于 2015-08-21 09:18:11 发布

阅读量4.5k

点赞数 1

分类专栏： sql 文章标签： sql Oracle

本文链接：https://blog.youkuaiyun.com/Rocky19890818/article/details/84738450

版权

sql 专栏收录该内容

13 篇文章

订阅专栏


create table YEAR_SALES
(
  YEAR     VARCHAR2(4),
  QUANTITY NUMBER
)
;

prompt Loading YEAR_SALES...
insert into YEAR_SALES (YEAR, QUANTITY)
values ('2001', 100);
insert into YEAR_SALES (YEAR, QUANTITY)
values ('2002', 200);
insert into YEAR_SALES (YEAR, QUANTITY)
values ('2003', 220);
insert into YEAR_SALES (YEAR, QUANTITY)
values ('2004', 260);
insert into YEAR_SALES (YEAR, QUANTITY)
values ('2005', 300);
insert into YEAR_SALES (YEAR, QUANTITY)
values ('2006', 330);
commit;

select t1.year, t1.quantity / t2.quantity increase_rate
  from year_sales t1
 inner join year_sales t2 on t1.year - 1 = t2.year