CREATE TABLE Emp(
EmpNo INT,
EmpName VARCHAR(50),
Job VARCHAR(50),
Basic DECIMAL(10,2),
DA DECIMAL(10,2),
HRA DECIMAL(10,2),
PF DECIMAL(10,2),
GrossPay DECIMAL(10,2),
NetPay DECIMAL(10,2)
);
SELECT * FROM Emp;
ALTER TABLE Emp ADD COLUMN EmailId INT PRIMARY KEY;
SELECT * FROM Emp;
INSERT INTO Emp VALUES(1,'A','HR',0.1,0.3,0.4,0.2,0.8,0.6);
INSERT INTO Emp VALUES(2,'B','MD',0.2,0.4,0.3,0.1,0.9,0.8);
INSERT INTO Emp VALUES(3,'C','Manager',0.3,0.2,0.4,0.4,0.9,0.5);
INSERT INTO Emp VALUES(4,'D','MD',0.4,0.1,0.5,0.4,1.0,0.6);
INSERT INTO Emp VALUES(5,'E','HR',0.5,0.3,0.4,0.3,1.2,0.9);
Telegram: DB developers channel