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 vote186 views1 answer
Creation d'un trigger sql
SQL
2 votes184 views1 answer
Mysql add boolean column
SQL
0 vote267 views2 answers
Search stored procedures by name
SQL
1 vote205 views1 answer
Limit offset order by mysql
SQL
1 vote181 views1 answer
Sql server list locks
SQL
0 vote206 views1 answer
Add column not null with default value postgres
SQL
1 vote192 views1 answer
Sql random sampling per group
SQL
19 votes196 views3 answers
Grant mysql
SQL
1 vote185 views1 answer
Create new table in SQL from old table with data
SQL
0 vote172 views1 answer
Postgresql create user roles
SQL