Q
Which UPDATE correctly sets a value from a subquery?
-
A
UPDATE emp SET salary = SELECT MAX(salary) FROM emp WHERE id = 5;
-
B
UPDATE emp WITH (SELECT MAX(salary)) WHERE id = 5;
-
C
UPDATE emp SET salary = FROM (SELECT MAX(salary)) WHERE id = 5;
-
D
UPDATE emp SET salary = (SELECT MAX(salary) FROM emp) WHERE id = 5;
Correct Answer:
D. UPDATE emp SET salary = (SELECT MAX(salary) FROM emp) WHERE id = 5;
Explanation:
A scalar subquery must return exactly one value and be enclosed in parentheses.
