SQLize Online / PHPize Online  /  SQLtest Online

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);