1、
SELECT
e.depid,avg(s.bonussalary+s.basesalary) AS avgsal from employ e,salary s
where e.employId=s.employId GROUP BY e.depid
ORDER BY avgsal asc
注意顺序 select from where group by oder by
2、
SELECT * from employ e where e.ename like ‘王%‘
oracle-统计员工x
标签：asc 注意 group by from ase 员工 rom acl alt