yes you can use select statment in update
Example:-
update employees
set salary=10000
where employee_id=select employee_id from employees where last_name='king' and department_id=10;
Type: Posts; User: rajgupta7666; Keyword(s):
yes you can use select statment in update
Example:-
update employees
set salary=10000
where employee_id=select employee_id from employees where last_name='king' and department_id=10;