SQL_Concept.pptVIP

Updating Rows with a Multiple-Column Subquery Multiple-column subqueries can be implemented in the SET clause of an UPDATE statement. Syntax Class Management Note It may be worth showing participants that the results would be the same for the example on the slide if two different subqueries were used in the SET clause as illustrated below: SQL UPDATE emp 2 SET job = (SELECT job FROM emp 3 WHERE empno = 7499), 4 deptno = (SELECT deptno FROM dept 5 WHERE dname = SALES) 6 WHERE empno = 7698; UPDATE table SET (column, column, ...) = (