1. 显示工资涨幅，员工编号，原来的工资和增加的工资：部门号10、50、110的有5%的涨幅，部门号为60的涨10%的工资部门号为20和80涨幅为15%，部门为90的不涨工资

最新推荐文章于 2022-07-29 23:13:19 发布

八月的冰可乐

最新推荐文章于 2022-07-29 23:13:19 发布

阅读量1.8k

点赞数

CC 4.0 BY-SA版权

文章标签： oracle'

本文链接：https://blog.youkuaiyun.com/ok3356/article/details/81104209


SELECT *
  FROM ( select 'raise 5%' raise,e.employee_id as employee_id,e.salary,e.salary*0.05 as newsalary
      from employees e
      where e.department_id in (10,50,110))
UNION ALL
SELECT *
  FROM ( select 'raise 10%' raise,e.employee_id as employee_id,e.salary,e.salary*0.10 as newsalary
      from employees e
      where e.department_id = 60)
UNION ALL
SELECT * FROM (select 'raise 15%' raise,e.employee_id as employee_id,e.salary,e.salary*0.15 as newsalary
      from employees e
      where e.department_id in (80,20))
union all
SELECT * FROM (select 'no raise' raise,e.employee_id as employee_id,e.salary,e.salary*0.00 as newsalary
      from employees e
      where e.department_id = 90)