Computer Science

Allocate the department situated in BOSTON to employee with employee number 7500 (tables EMPL, Dept)

DDL & DML

6 Likes

Answer

UPDATE EMPL
SET DEPTNO = (
    SELECT DEPTNO
    FROM Dept
    WHERE LOC = 'BOSTON'
)
WHERE EMPNO = 7500;

Answered By

4 Likes


Related Questions