全部博文
-
编辑 删除
sum()over()和count()over()分析函数
Sum()over()和count()over分析函数使用创建测试表create table test(sales_id varchar2(2),sales varchar2(10),dest varchar2(10),dept varchar2(10),revenue number);插入测试数据insert into test values('11','smith','hangzhou','市场',1000);insert into test values('12','smith','wenzhou','市场',2000);insert into test values('13','allen','wenzhou','渠道',3000);insert into test values('14','allen','wenzhou','渠道',4000);insert into test values('15','jekch','shanghai','渠道',2500);insert into test values('11','
