Sqlite update where exists

UPDATE employees
SET hire_date = (SELECT departments.start_date
                 FROM departments
                 WHERE departments.department_id = employees.department_id
                 AND departments.department_name = 'HR')
WHERE EXISTS (SELECT *
              FROM departments
              WHERE departments.department_id = employees.department_id
              AND departments.department_name ='HR');

Source: techonthenet.com

Similar codes

3 votes333 views1 answer
Set default today mysql
SQL
0 vote334 views1 answer
Postgresql on conflict pair
SQL
-3 votes416 views8 answers
Sql to c# linq converter online
SQL
0 vote320 views1 answer
Sql server system messeges
SQL
0 vote349 views1 answer
Left join vs inner join performance
SQL
1 vote331 views1 answer
Mysql select for update ejemplo
SQL
1 vote340 views1 answer
Sql server 2012 query history
SQL
0 vote337 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote318 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
5 votes341 views3 answers
Mysql remove unique constraint
SQL