Which statement is used to update multiple rows in a single query?
Answer options
A
WHERE clause (no additional keyword needed)
B
AND
C
WHEN
D
IN
Correct answer: WHERE clause (no additional keyword needed)
Explanation
A single UPDATE with a WHERE clause can update multiple rows simultaneously without extra keywords.