Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 58 of 79

Table Creation and Data Manipulation Commands — Question 4

Back to all questions
4
Question

Question 4

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

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