Create a table T_Employee and insert some data
Copy codeThe Code is as follows:
Create table T_Employee (FNumber VARCHAR (20), FName VARCHAR (20), FAge int, FSalary NUMERIC (10, 2), primary key (FNumber ));
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('dev001', 'Tom );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('dev002 ', 'Jerry', 28,230 0.80 );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('sales001', 'john );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('sales002', 'kerry );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('sales003 ', 'stone );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('hr001', 'Jane ', 23,220 0.88 );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('hr002 ', 'tina', 25,520 0.36 );
Insert into T_Employee (FNumber, FName, FAge, FSalary) values ('it001', 'Smith ', 28, 3900 );
Insert into T_Employee (FNumber, FAge, FSalary) values ('it002', 27,2800 );
You can find out how to use the create and insert commands.