select deptno,job--count(*)
from emp
group by deptno,job;
--having 对分组后的信息进行筛选
--having子句出现的字段必须是分组之后组的整体信息,不能出现组内详细信息;
select deptno,avg(sal)
from emp
group by deptno
having avg(sal)>2000;
--having与where的异同
select deptno,avg(sal)
from emp
where ename not like '%A%'--sal>2000 where对原始记录过滤;
group by deptno
having avg(sal)>2000;
select deptno,avg(sal)
--into emp_2
from emp
where ename not like '%A%'
group by deptno
having avg(sal)>2000
--select *from emp_2;
SQL having,where的区别
最新推荐文章于 2024-10-12 22:28:01 发布