编辑代码

CREATE TABLE spayroll (
	id int,
    empId int,
    baseSalary double,
    actualSalary double,
    bonus double,
    deductMoney double,
	grantDate date
);

INSERT INTO payroll VALUES (1, '0001', '1000', '1000','1000','10','2021-06-06');
INSERT INTO payroll VALUES (2, '0002',  '1000', '1000','1000','10','2021-06-06');
INSERT INTO payroll VALUES (3, '0003', '1000', '1000','1000','10','2021-06-06');
INSERT INTO payroll VALUES (4, '0004',  '1000','1000', '1000','10','2021-06-06');
INSERT INTO payroll VALUES (5, '0005', '1000', '1000','1000','10','2021-06-06');


SELECT * FROM payroll;