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

2 votes303 views1 answer
Mysql id of inserted row
SQL
0 vote266 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote278 views1 answer
Sql trying to delete database in use
SQL
2 votes267 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote289 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote300 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote282 views2 answers
Sqlite unique
SQL
5 votes322 views3 answers
Sql limit offset
SQL
0 vote284 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote311 views1 answer
Sql create and grant user access to database
SQL