Oracle分析函数

本文讲述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）;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;

Oracle SQL基础ORA-00060错误相关资讯 Oracle函数

Oracle字符串函数总结（06月20日）
Oracle lag（）与lead（）函数（12/01/2015 20:41:24）
Oracle ascii函数（07/26/2015 08:46:01）

Oracle使用简单函数（06月09日）
REGEXP_SUBSTR函数的整理（08/20/2015 20:41:01）
Oracle dump函数（07/26/2015 08:40:01）

本文评论查看全部评论（0）