There is a table called Employee having columns are empno, ename , job , deptno,grade and salary. Which of the following is a correct query to change all emp salary with salary<10000 to 1.5 times and grade to ‘Promo’
Update Employee set salary = salary * 1.5 and grade=’Promo’ where salary < 10000;
Update Employee set salary = salary * 1.5, grade=’Promo’ where salary < 10000;
Update table Employee set salary = salary * 1.5, grade=’Promo’ where salary < 10000;
Update table Employee set salary = salary * 1.5 and grade=’Promo’ where salary < 10000;