oracle --查询语句
一 查询员工的编号,姓名,职位,月薪,年薪
1 语句
select empno as "员工编号" , ename "员工姓名" , job as "职位",hiredate 入职时间 , sal as "月薪" ,sal*12 as "年薪"from emp;
2 结果
二 查询员工姓名 ,月薪,年薪 ,年收入
1 语句
select ename as "姓名" , sal as "月薪" ,comm as" 佣金" ,sal*12 as"年薪" ,sal*12+comm as "年收入" from emp;
2 截图
3 如何让simth等人的年收入有值?
1 使用nvl函数, nvl(a,b):如果a的值是null则用b的值替代null。(此例中comm的值为null时会用0代替null)
select ename as "姓名" , sal as "月薪" ,comm as" 佣金" ,sal*12 as"年薪" ,sal*12+nvl(comm,0) as "年收入" from emp;
2 结果