Mysql数据库_ 视图.sql

/*
//实图
*/
#简单视图
create view emp_v_10 as
select empno as 部门编号, ename 员工姓名, sal 工资
form deptno =10;
select 8 from emp_v_10;--视图
#复杂视图
select deptno as 部门编号,
           AVG(sal) as 平均工资,
  MAX(sal) as 最高工资,
  MIN(sal) as 最低工资,
  SUM(sal) as 工资总数,
  COUNT(1) 部门人数
from tb_emp
group by deptno;
 select * from emp_v;--视图