weixin_42662567的博客

–1.创建数据库DB_AuthCreate database DB_Auth–2.删除数据库DB_Authdrop database DB_Auth–3.在指定位置创建数据库DB_AuthCreate database DB_Authon primary(name='DB_Auth_data',filename = 'F:\sql数据库\数据库面试题\201717380139张...

查询各部门人数,男员工数,女员工数(要求显示部门名称,总数,男员工数,女员工数)select d.Name ‘部门名’,COUNT(*) as ‘总人数’,sum(case e.sex when ‘男’ then 1 else 0 end) ‘男’,sum(case e.sex when ‘女’ then 1 else 0 end) ‘女’from Employee e,Departme...