摘要： 分别创建两个视图emp_deptview、emp_jobview，按部门、职位分别统计所有员工的年薪. create view emp_deptview as select sum(12*(sal+ifnull(comm,0))) from emp group by deptno; select * 阅读全文