select * from emp
where
sal>(select avg(sal) as ssal
from emp);
--要求查询出高于公司平均工资的全部雇员信息
转载于:https://www.cnblogs.com/hyx0920/p/7171580.html
select * from emp
where
sal>(select avg(sal) as ssal
from emp);
--要求查询出高于公司平均工资的全部雇员信息
转载于:https://www.cnblogs.com/hyx0920/p/7171580.html