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
Increase salary of employee records by 10% (table employee).
Give commission of Rs.500 to all employees who joined in year 1982 (table Empl).
Given the following tables :
Orders (OrdNo, Ord_date, ProdNo#, Qty) Product (ProdNo, Descp, Price) Payment (OrdNo, Pment)Write a query to delete all those records from table Orders whose complete payment has been made.
Enlist the names of all tables created by you.