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 vote167 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote171 views1 answer
How to to get current date in sql
SQL
0 vote180 views1 answer
How we can perform acid Operations in sql with examples
SQL
-1 vote177 views1 answer
Phinehas Psalm 106
SQL
0 vote207 views1 answer
Sql alter column name sql server
SQL
0 vote173 views1 answer
Sql server remove 0 from left
SQL
0 vote225 views1 answer
ORACLE PARSE STRING
SQL
1 vote167 views1 answer
How to install mysql 8.0 windows service
SQL
6 votes183 views2 answers
Sql query to get the number of rows in a table
SQL
4 votes203 views2 answers
Insert current date in mysql
SQL