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 vote143 views1 answer
Get week day name sql server
SQL
0 vote154 views1 answer
Querry mysql by 2 columns
SQL
0 vote165 views1 answer
Reindex mssql table
SQL
2 votes157 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote138 views1 answer
Check mysql password with docker container magento 2
SQL
3 votes173 views1 answer
Set default today mysql
SQL
-1 vote157 views1 answer
Default username and password for oracle 11g
SQL
5 votes162 views1 answer
Oracle list functions
SQL
1 vote116 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote154 views2 answers
Postgresql get long running queries
SQL