创建员工信息表

1. 创建数据库 wtf

create database wtf 

use wtf 

 

2. 创建dp表

if exists (select * from sys.objects where name ='dp' and type='U')

drop table dp

(

 

 kname varchar(20),

 kno int primary key,

 cr int,

 comm int,

 sal int,

 kz nvarchar(20),

 dpno varchar(20)

 insert into dp 

values('Jim',2,2,3000,8500,'经理',1);

 insert into dp 

values('Tom',3,1,4000,90000,'经理',2);

 insert into dp 

values('John',4,2,2000,7600,'经理',2);

insert into dp 

values('Stenven',5,1,3200,7800,'程序员',2);

insert into dp 

values('John',4,2,2000,7600,'经理',2);

insert into dp 

values('Stenven',5,1,3200,7800,'程序员',2);

insert into dp 

values('Jim',2,2,3000,8500,'经理',1);

insert into dp 

values('Tom',3,1,4000,90000,'经理',2);

insert into dp 

values('John',4,2,2000,7600,'经理',2);

insert into dp 

values('Stenven',5,1,3200,7800,'程序员',2);

insert into dp 

values('Kati',6,1,6000,9500,'经理',3);

insert into dp 

values('Lisa',7,2,2200,3800,'程序员',2);

insert into dp 

values('Linken',8,1,1200,41800,'项目组长',3);

insert into dp 

values('Kalen',9,1,2500,4200,'程序员',1);

 

 找出奖金高于薪水60%的员工信息

 找出部门1中经理和部门2中程序员的详细资料