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 '王%'
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 '王%'