【项目实战】SQL ：部门花名册PBI展示

SQL ：部门花名册PBI展示

编号                  姓名	            部门  	   职位             联系方式	     性别	       生日		   住址
id（标识列）     name           dept             position           mobile                  gender     birth_date             address


入职时间
离职时间



###查询数据库
select name from master..sysdatabases order by name;
go


###查询数据表
use 创新金融Family花名册
select name from SysObjects where XType='U' order by name
go

###查询数据
select * from 花名册
go
select id,name,dept,position,mobile,gender  
from 花名册
go

#########
高级查询
select id AS 编号, name AS 姓名, dept AS 部门, position AS 职位, mobile AS 联系方式, gender AS 性别
from 花名册
where dept  = '业务支持部'
and birth_date>'01/01/1950'
order by id
go


###插入数据
insert into 花名册
values ('017','赵x芳','业务支持部','客服','1371xxxx3259','女','1321-09-21','朝阳区','')
go

###更新数据 
update 花名册
set employee_id  = '015'
where name = '肖x华'
go

###
delete from 花名册
where id = 16
go

select name,dept,position,mobile,gender  
from 花名册
group by gender
go


海淀区
select
from
where
group by
order by