Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE banco_teste;
- USE banco_teste;
- CREATE TABLE Cargos
- (
- CargoId INT NOT NULL,
- CargoNm VARCHAR(80),
- Min_Sal NUMERIC(10,2),
- Max_Sal NUMERIC(10,2),
- PRIMARY KEY (CargoId)
- );
- CREATE TABLE Funcionarios
- (
- FuncId INT NOT NULL,
- CargoId INT NOT NULL,
- FuncNm VARCHAR(80),
- Sal NUMERIC(10,2),
- PRIMARY KEY (FuncId),
- FOREIGN KEY (CargoId) REFERENCES Cargos(CargoId)
- );
- INSERT INTO Cargos VALUES(1, "Gerente", 1000, 3000) ;
- INSERT INTO Cargos VALUES(2, "Secretaria", 500, 800) ;
- INSERT INTO Cargos VALUES(3, "Office Boy", 300, 490) ;
- INSERT INTO Funcionarios VALUES(1, 1, "Ana", 2750) ;
- INSERT INTO Funcionarios VALUES(2, 2, "Maria", 825) ;
- INSERT INTO Funcionarios VALUES(3, 3, "Joao", 420) ;
- INSERT INTO Funcionarios VALUES(4, 3, "Miguel", 500) ;
- SELECT Funcionarios.FuncNm, Cargos.CargoNm, Funcionarios.Sal, Cargos.Max_Sal
- FROM Funcionarios JOIN Cargos
- ON (Cargos.CargoId = Funcionarios.CargoId);
- SELECT Funcionarios.FuncNm, Cargos.CargoNm, Funcionarios.Sal, Cargos.Max_Sal
- FROM Funcionarios JOIN Cargos
- ON (Cargos.CargoId = Funcionarios.CargoId)
- WHERE Funcionarios.Sal > Cargos.Max_Sal;
Add Comment
Please, Sign In to add comment