update from 表 set salary=salary*1.105 where name='a'select department_name from 表 where department_id=30
--问题一 update employees set salary=salary*10.5% where name='a' --问题二 select depart_name,COUNT(id)as 员工数量 from department d where d.department_id=30 join employees e on d.department_id=e.department_id
这个应该这样写吧update employees set salary=salary*1.105 where name='a'
UPDATE employees SET salary = salary * 1.105 WHERE NAME = 'a'
SELECT departmentname , COUNT(1) 员工数量 FROM department WHERE department_id = 30 GROUP BY departmentname
UPDATE employees SET salary = salary * 1.105 WHERE NAME = 'a'
SELECT departmentname , COUNT(b.id) 员工数量 FROM department a INNER JOIN Employees b ON a.department_id = B.department_id WHERE department_id = 30 GROUP BY departmentname
update Employees set salary=salary*1.105 where name='a'select department_name,count(*) as '员工数量' from Employees a,Department b where a.department_id=b.department_id and b.department_id=30
update from Employees set salary=salary*1.105 where name='a'select department_name,count(id) from Department where department_id=30 GROUP BY departmentname
--问题一
update employees
set salary=salary*10.5% where
name='a'
--问题二
select depart_name,COUNT(id)as 员工数量 from
department d
where d.department_id=30 join employees e on
d.department_id=e.department_id
set salary=salary*1.105 where
name='a'
SET salary = salary * 1.105
WHERE NAME = 'a'
SELECT departmentname ,
COUNT(1) 员工数量
FROM department
WHERE department_id = 30
GROUP BY departmentname
你好像看错题了。你不和employees表连接能得出员工数量吗
UPDATE employees
SET salary = salary * 1.105
WHERE NAME = 'a'
SELECT departmentname ,
COUNT(b.id) 员工数量
FROM department a
INNER JOIN Employees b ON a.department_id = B.department_id
WHERE department_id = 30
GROUP BY departmentname
from Employees a,Department b
where a.department_id=b.department_id and b.department_id=30