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 vote144 views1 answer
Mysql aspas simples
SQL
3 votes144 views2 answers
Sql not contains
SQL
3 votes115 views1 answer
Sql select all
SQL
0 vote77 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote84 views1 answer
Get last run query sql server
SQL
1 vote110 views2 answers
T sql get foreign key
SQL
15 votes133 views4 answers
Pl sql
SQL
0 vote236 views1 answer
Why do we need data structure in sql
SQL
0 vote145 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote138 views1 answer
Query archive mode
SQL