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

1 vote378 views1 answer
Postgresql float 2 decimal places
SQL
0 vote315 views1 answer
Add column not null with default value postgres
SQL
0 vote334 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote340 views1 answer
How to get specific salary in sql
SQL
2 votes363 views3 answers
Mysql kill
SQL
3 votes325 views2 answers
Mysql create timestamp column
SQL
0 vote334 views1 answer
Assign value to var in SQL
SQL
0 vote350 views1 answer
Postgre query date
SQL
4 votes313 views1 answer
Check database name postgresql
SQL
0 vote655 views1 answer
Create pl/sql stored procedure
SQL