UC知道如何将两个select语句合为一条
来源：百度知道 编辑：UC知道 时间：2024/06/19 23:21:44
统计出各部门的人数和各部门姓“李”的人数，用一条SQL语句完成。
我分别写出了两条sql语句是
select count(*),Department from Employee group by Department;
select count(*) as 姓李人数,Department from Employee where Name like ('李%')group by Department;
这要是写一条该怎么写啊？
我分别写出了两条sql语句是
select count(*),Department from Employee group by Department;
select count(*) as 姓李人数,Department from Employee where Name like ('李%')group by Department;
这要是写一条该怎么写啊？
select Department,count(*) as 部门总数,sum(case when Name like N'李%' then 1 else 0 end) as 姓李人数
from Employee
group by Department
实在不行你还是用子查询比较清晰吧：
select a.Department ，a.部门人数 , b.姓李人数
from ( select count(*) as 部门人数,Department from Employee group by Department) a left join
（select count(*) as 姓李人数,Department from Employee where Name like ('李%')group by Department） b on a.Department = b.Department