救命啊 我的update语句怎么写?

[dudeng]

要求是这样的:
有个employee表有四个字段id,name,age,salary
表的内容:
id name age salary
1 aa 23 3000
2 dd 22 4000
3 ee 24 3200
4 ff 28 3000

现在我要将该表中salary最高的人的工资下调10%.请问sql语句怎么写?
我的写法通不过啊:update employee set salary = (select max(salary) from employee);请问错哪里了?
在线等..........没分给了 下次补上

[gahade]

update employee
set salary = salary * 0.9
from employee
where salary in (select max(salary) from employee)

[wendyc]

楼主的SQL是将所有人的工资调为最高工资*0.9

[九斤半]

CREATE TABLE EMPLOYEE(id INT,name NCHAR(10),age INT,salary MONEY)
INSERT EMPLOYEE
SELECT 1,'aa',23,3000 UNION ALL
SELECT 2,'dd',22,4000 UNION ALL
SELECT 3,'ee',24,3200 UNION ALL
SELECT 4,'ff',28,3000
SELECT * FROM EMPLOYEE

UPDATE EMPLOYEE SET SALARY=SALARY*0.9 WHERE SALARY=(SELECT MAX(SALARY) FROM EMPLOYEE)

SELECT * FROM EMPLOYEE

DROP TABLE EMPLOYEE

[九斤半]

UPDATE EMPLOYEE SET SALARY=SALARY*0.9 WHERE SALARY=(SELECT MAX(SALARY) FROM EMPLOYEE)

[killxtt]

几位老大的写法都是一样的，呵呵，不能让我们新手蹭点分吗。

[蓝色风影]

update employee set salary = salary * 0.9 where salary = (select max(salary) from employee)

[dudeng]

感谢上面的兄弟