Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CONSTRAIT employess
- FOREIGN KEY (deptID)
- REFERENCES Employee(id)
- ON DELETE CASCADE
- ON UPDATE CASCADE,
- CONSTRAIT pr_key
- PRIMARY KEY (emplID,deptID) ON CONFLICT ROLLBACK
- );
- INSERT INTO Hired VALUES(101,1)
- INSERT INTO Hired VALUES(102,3,15000)
- INSERT INTO Hired VALUES(103,3,28000)
- INSERT INTO Hired VALUES(104,2,32000)
- INSERT INTO Hired VALUES(105,3,21000)
- SELECT * FROM Department WHERE location LIKE 'Par%';
- SELECT * FROM Employee WHERE id in
- (SELECT emplID FROM Hired WHERE deptID IS 3);
- SELECT * FROM Employee WHERE id in
- (SELECT emplID FROM Hired WHERE deptID in
- (SELECT id FROM Department WHERE name LIKE 'Sal%'));
- CREATE View TechEmpl(id,name,title) AS
- SELECT id,name,title FROM Employee WHERE id in
- (SELECT emplID FROM Hired WHERE deptID IS 3);
- CREATE View Salary (salary,name,department) AS
- SELECT Hired.salary, Employee.name, Department.name
- FROM Employee, Hired,Department
- WHERE Employee.id = Hired.emplID AND Hired,deptID = Department.id
- ORDER BY Hired.salary;
- SELECT * FROM TechEmpl ORDER BY name ASC;
- SELECT * FROM Salary ORDER BY salary DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement