select 姓名,科室, sum(case when 字段A is null then 1 else 0 end) as 字段A, sum(case when 字段B is not null then 1 else 0 end) as 字段B from Table1 group by 姓名,科室
34,837
社区成员
254,632
社区内容
加载中
试试用AI创作助手写篇文章吧