sy3_1.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 20 行

insert into person
       values ('000008','孙烨','女','1982-6-25','初级','00102')
insert into person
       values ('000009','苏友','男','1958-9-9','高级','00101')
insert into pay
       values ('000001',2005,2,2200,300,162.5)
insert into pay
       values ('000002',2005,2,2800,500,203.2)
insert into pay
       values ('000003',2005,2,2200,350,165.5)
insert into pay
       values ('000004',2005,2,2200,300,162.5)
insert into pay
       values ('000005',2005,2,2800,500,203.2)
insert into pay
       values ('000006',2005,2,1800,300,148.3)
insert into dept
       values ('00104','研发部')
insert into dept
       values ('00105','后勤部')