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

7 votes195 views1 answer
Postgres base size
SQL
1 vote217 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote269 views1 answer
Delete ids between sql
SQL
31 votes190 views1 answer
Postgresql add column with constraint
SQL
1 vote201 views1 answer
Sql server insert into temp table
SQL
5 votes203 views4 answers
Change auto increment mysql
SQL
0 vote180 views1 answer
How to update random rows in sql
SQL
0 vote189 views1 answer
Sqlserver now
SQL
0 vote195 views1 answer
Ms sql database data size
SQL
0 vote206 views1 answer
Oracle NLS_CHARACTERSET
SQL