An SQL statement to change the salary of all employees belonging to Research department by 10% can be

Question

Answer

update employee salary = 1.1*salary where dno = (select dnumber from department where dname = 'Research')

Answer

None of these

Answer

update employee, department where dno = dnumber set salary = 1.1*salary where dname = 'Research'

Answer

update employee set salary = 1.1*salary where dno = (select dnumber from department where dname = 'Research')

Crowdly