sy3_1.sql

关于SQL数据库的实验代码和程序及一些函数的应用

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','后勤部')