再讲讲所谓的开窗函数，依本人遇见，开窗函数就是 over([query_partition_clase] order_by_clause)。比如说，我采用sum求和，ran
本文讲述oracle分析函数用法，，首先建库：
create table earnings — 打工赚钱表
(
earnmonth varchar2(6), — 打工月份
area varchar2(20), — 打工地区
sno varchar2(10), — 打工者编号
sname varchar2(20), — 打工者姓名
times int, — 本月打工次数
singleincome number(10,2), — 每次赚多少钱
personincome number(10,2) — 当月总收入
)
然后插入实验数据：
insert into earnings values(‘200912′,’北平’,’511601′,’大魁’,11,30,11*30);
insert into earnings values(‘200912′,’北平’,’511602′,’大凯’,8,25,8*25);
insert into earnings values(‘200912′,’北平’,’511603′,’小东’,30,6.25,30*6.25);
insert into earnings values(‘200912′,’北平’,’511604′,’大亮’,16,8.25,16*8.25);
insert into earnings values(‘200912′,’北平’,’511605′,’贱敬’,30,11,30*11);
insert into earnings values(‘200912′,’金陵’,’511301′,’小玉’,15,12.25,15*12.25);
insert into earnings values(‘200912′,’金陵’,’511302′,’小凡’,27,16.67,27*16.67);
insert into earnings values(‘200912′,’金陵’,’511303′,’小妮’,7,33.33,7*33.33);
insert into earnings values(‘200912′,’金陵’,’511304′,’小俐’,0,18,0);
insert into earnings values(‘200912′,’金陵’,’511305′,’雪儿’,11,9.88,11*9.88);
insert into earnings values(‘201001′,’北平’,’511601′,’大魁’,0,30,0);
insert into earnings values(‘201001′,’北平’,’511602′,’大凯’,14,25,14*25);
insert into earnings values(‘201001′,’北平’,’511603′,’小东’,19,6.25,19*6.25);
insert into earnings values(‘201001′,’北平’,’511604′,’大亮’,7,8.25,7*8.25);
insert into earnings values(‘201001′,’北平’,’511605′,’贱敬’,21,11,21*11);
怪兽AI数字人
数字人短视频创作，数字人直播，实时驱动数字人
44 查看详情
insert into earnings values(‘201001′,’金陵’,’511301′,’小玉’,6,12.25,6*12.25);
insert into earnings values(‘201001′,’金陵’,’511302′,’小凡’,17,16.67,17*16.67);
insert into earnings values(‘201001′,’金陵’,’511303′,’小妮’,27,33.33,27*33.33);
insert into earnings values(‘201001′,’金陵’,’511304′,’小俐’,16,18,16*18);
insert into earnings values(‘201001′,’金陵’,’511305′,’雪儿’,11,9.88,11*9.88);
然后看看刚刚建好的库：
select * from earnings;
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/554661.html
微信扫一扫 
支付宝扫一扫 
