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

0 vote273 views1 answer
Redshift running queries
SQL
0 vote233 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote210 views1 answer
Insert thai language sql server
SQL
0 vote213 views1 answer
Restore backupfile discourse
SQL
0 vote232 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
1 vote202 views1 answer
Mysql average of multiple columns
SQL
0 vote214 views1 answer
Mssql view column data type
SQL
3 votes221 views2 answers
How to modify rows in SQL Server
SQL
0 vote287 views1 answer
Python get backup of sql
SQL
1 vote218 views1 answer
SQL date part only of datetime
SQL