你需要将所属部门名称为“SALES”的所有员工的工资增加10%，你需用哪一句实现? ( )
UPDATE emp SET sal = sal * 1.1 WHERE dname LIKE 'SALES' ;
UPDATE emp SET sal = sal * 1.1 WHERE deptno =(SELECT deptno FROM emp WHERE dname LIKE 'SALES' );
UPDATE emp SET sal = sal * 1.1 WHERE dname =(SELECT deptno FROM emp WHERE dname LIKE 'SALES' );
UPDATE emp SET sal = sal * 1.1 WHERE deptno =(SELECT dname FROM emp WHERE dname LIKE 'SALES' )
