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 vote347 views1 answer
Run postgresql dump to csv
SQL
1 vote375 views1 answer
Postgres power
SQL
-1 vote364 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote348 views1 answer
Scaffold mysql database
SQL
0 vote362 views1 answer
Azure sql server check foreign key
SQL
1 vote353 views1 answer
Oracle index partition
SQL
0 vote345 views1 answer
Why mysql is used?
SQL
0 vote350 views1 answer
Sql server select top 2 of each group
SQL
0 vote367 views1 answer
Str_to_date sql server
SQL
0 vote421 views1 answer
Alternative for LIMIT sql
SQL