p100

create table emp(

empno INT PRIMARY KEY,

ename VARCHAR(20),

job VARCHAR(20),

mgr INT,

hiredate DATE,

sal NUMERIC(8,2),

comm NUMERIC(8, 2),

deptno INT

);

insert into emp values(1001,'甘寧','文員', 1013,'2000-12-12',8000.00,null,20),

?(1002,'黛綺絲','銷售員', 1006,'2001-02-20',16000.00,3000.00,30),

?(1003,'殷天正','銷售員', 1006,'2001-02-22',12500.00,5000.00,30),

??????? ?(1004,'劉備','經(jīng)理', 1009,'2001-04-02',29750.00,null,20),

?(1005,'謝遜','銷售員', 106,'2001-09-28',12500.00,14000,30),

?(1006,'關羽','經(jīng)理',1009,'2001-05-01',28500.00,null,30),

?(1007,'張飛','經(jīng)理',1009,'2001-09-01',24500.00,null,10),

?(1008,'諸葛亮','分析師',1004,'2007-04-19',30000.00,null,20),

?(1009,'增阿牛','董事長',null,'2001-11-17',50000.00,null,10),

?(1010,'韋一笑','銷售員',1006,'2001-09-08',15000.00,0.00,30),

?(1011,'周泰','文員',1008,'2007-05-23',11000.00,null,20),

?(1012,'程管','文員',1006,'2001-12-03',9500.00,null,30),

?(1013,'龐統(tǒng)','分析師',1004,'2001-12-03',30000.00,null,20),

?????????(1014,'黃蓋','文員',1007,'2002-01-23',13000.00,null,10);