Which of the following query used for updating salary and doj of employee id 4 with 27600 and 20th february 2010?
update table employees where salary=27600 and doj='20th feb 2010' where eid=4
update employees set salary=27600,doj='02-20-2010' where eid=4
update table employees set salary=27600 and doj=02-20-2010 where eid=4
update employees set salary=27600,doj=02-20-2010 where eid=4
1.Where clause must not be present two times.
3.table keyword is incorrect immediately after update keyword.
4.Fourth query will not execute since data type mismatch error will come.
Back To Top