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 vote340 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote296 views1 answer
View to table
SQL
0 vote323 views1 answer
Normalization in database
SQL
1 vote301 views1 answer
Select inside insert query
SQL
5 votes297 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
7 votes293 views1 answer
Append column sql
SQL
0 vote316 views1 answer
Get enginge db mysql
SQL
0 vote671 views1 answer
Sql field equals multiple values
SQL
1 vote273 views1 answer
Full text index mysql
SQL
4 votes327 views2 answers
Oracle unlock account
SQL