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 vote175 views1 answer
Insert value in identity
SQL
0 vote152 views1 answer
Change role postgres
SQL
0 vote151 views1 answer
T-sql update table variale
SQL
0 vote193 views1 answer
Sql select without column name
SQL
2 votes144 views2 answers
Exec procedure pl sql
SQL
-1 vote163 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote182 views2 answers
Mysql add column tinyint default 0
SQL
1 vote102 views1 answer
Postgresql last element of array
SQL
0 vote157 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote146 views2 answers
Postgres default user
SQL