values('20113','业务六',4) insert into operation values('30416','业务七',3) insert into operation values('20327','业务八',2) insert into operation values('20521','业务九',2) insert into operation values('30213','业务十',4) insert into operation values('11101','业务一一',2) insert into operation values('21003','业务一二',4) insert into operation values('30211','业务一三',3) insert into operation values('30232','业务一四',2) insert into operation values('40711','业务一五',2) insert into operation values('40722','业务一六',2) insert into operation values('30832','业务一七',4) insert into operation values('10812','业务一八',4) insert into operation values('10715','业务一九',4) insert into operation values('20111','业务二一',3)
- 21 -
insert into operation values('30802','业务二二',3) insert into operation values('30423','业务二三',3) insert into operation values('40331','业务二四',2) insert into operation values('40625','业务二五',2) insert into operation values('20314','业务二六',2) insert into operation values('10811','业务二七',2) insert into operation values('30819','业务二八',4) insert into operation values('20534','业务二九',4) insert into operation values('10712','业务三一',3) insert into operation values('20115','业务三二',4) insert into operation values('10222','业务三三',2) insert into operation values('30412','业务三四',2) insert into operation values('40316','业务三五',2) insert into operation values('40612','业务三六',3) insert into operation
- 22 -
values('20328','业务三七',4) go
Use department go
insert into wages
values('9805026','20801',75) insert into wages
values('9702033','30802',80) insert into wages
values('9907002','11001',91) insert into wages
values('9801055','20113',70) insert into wages
values('9902006','11001',78) insert into wages
values('9704001','30416',80) insert into wages
values('9803011','20327',95) insert into wages
values('9908088','11001',90) insert into wages
values('9805026','20521',90) insert into wages
values('9702033','30213',88) insert into wages
values('9907002','11101',88) insert into wages
values('9801055','21003',70) insert into wages
- 23 -
values('9902006','11101',88) insert into wages
values('9803011','21003',78) insert into wages
values('9908088','11101',82) insert into wages
values('9805026','21003',83) insert into wages
values('9805026','20511',90) insert into wages
values('9702033','30232',80) insert into wages
values('9907002','10101',84) insert into wages
values('9801055','20801',76) insert into wages
values('9902006','10101',85) insert into wages
values('9704001','30802',90) insert into wages
values('9803011','20801',60) insert into wages
values('9607039','40711',85) insert into wages
values('9907002','10715',83) insert into wages
values('9801055','20111',78) insert into wages
values('9902006','10218',75)
- 24 -
insert into wages
values('9704001','30423',80) insert into wages
values('9603001','40331',67) insert into wages
values('9606005','40625',83) insert into wages
values('9803011','20314',76) insert into wages
values('9908088','10811',82) insert into wages
values('9608066','30819',78) insert into wages
values('9907002','10712',90) insert into wages
values('9801055','20115',80) insert into wages
values('9902006','10222',85) insert into wages
values('9704001','30412',78) insert into wages
values('9603001','40316',66) insert into wages
values('9606005','40612',70) insert into wages
values('9803011','20328',90) insert into wages
values('9908088','10812',80) insert into wages
- 25 -