What is the result of the following SQL statement?
UPDATE employee
SET salary = 50000
WHERE salary

Question

What is the result of the following SQL statement?
UPDATE employee
SET salary = 50000
WHERE salary < 50000;
A)The statement sets the salary for each employee to below 50,000
B)The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000
C)The statement increases salary to 50,000 for each employee whose salary is below 50,000
D)The statement sets the salary of each employee to 50,000

Quizplus · Accepted Answer

The statement increases salary to 50,000 for each employee whose salary is below 50,000. The WHERE clause specifies that the update should only apply to employees whose current salary is less than 50,000. Therefore, the statement will not affect those employees whose salary is already set at or above 50,000.

What Is the Result of the Following SQL Statement