1, select dno,average(salary) from emp where salary >=600 group by dno;2, update emp set salary=salary * 1.1 where salary < 600;
select dept.dname ,avg(salary) from emp ,dept where emp.dno=dept.dno and emp.dno in ( select dno from emp group by dno having salary >=600 );update emp set salary=salary * 1.1 where salary < 600 and emp.dno=(select dno from dept where dname ="销售部门"; 可能不是最优,期待高手
select dept.dname ,avg(salary) from emp ,dept where emp.dno=dept.dno group by dept.dname having salary >=600
我第一题这样写的, select dname,avgSalary from dept,(select dno, avg(salary) avgSalary from emp group by dno) e where e.dno = dept.dno我习惯这样写了 但是那个面试官说不对, 是不是这种写法不被认可啊!
select dno,average(salary) from emp
where salary >=600
group by dno;2,
update emp set salary=salary * 1.1 where salary < 600;
select dept.dname ,avg(salary)
from emp ,dept where emp.dno=dept.dno and emp.dno in (
select dno from emp group by dno having salary >=600 );update emp set salary=salary * 1.1
where salary < 600 and emp.dno=(select dno from dept where dname ="销售部门";
可能不是最优,期待高手
from emp ,dept where emp.dno=dept.dno
group by dept.dname having salary >=600
select dname,avgSalary from dept,(select dno, avg(salary) avgSalary from emp group by dno) e where e.dno = dept.dno我习惯这样写了 但是那个面试官说不对,
是不是这种写法不被认可啊!
from emp,dept
where emp.dno= dept.dno and salary>600
group by dept.dno;