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

2 votes314 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
4 votes303 views1 answer
Is there any command to change postgres password
SQL
0 vote293 views1 answer
Select last 2 characters sql
SQL
2 votes310 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote309 views3 answers
Joins and views sql
SQL
0 vote311 views1 answer
Update and keep original value sql
SQL
0 vote324 views1 answer
Selecting duplicates
SQL
2 votes301 views2 answers
Get all columns from table sql
SQL
2 votes299 views2 answers
Compare date mysql
SQL
7 votes328 views5 answers
Oracle alter table
SQL