/*
//实图
*/
#简单视图
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;--视图
//实图
*/
#简单视图
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;--视图