Crowdly

Add to Chrome

A company wants to increase the salary by 10% only for employees earning less th...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

A company wants to increase the salary by 10% only for employees earning less than 3000. Consider the following SQL query:

<SQL>

UPDATE Employee

SET Salary = Salary * 1.1;

What is the issue with this query?

It only updates some employees

It has a syntax error

It updates all employees instead of only those earning less than 3000

100%

There is no issue

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome