写一个SQL语句 能查出 success 2 (status是T的个数) successTF 2 (status是TF的) error 2 （status是F)

Question

一句一句的我会查
能不能写一个sql搞定 我记得原来做项目就有 忘记怎么写的了。

Answer 1

Select CompanyName,
Sum(Case when Status='T' Then 1 Else 0 End) as Success2,
Sum(Case when Status='TF' Then 1 Else 0 End) as SuccessTF2,
Sum(Case when Status='F' Then 1 Else 0 End) as Error2
From 表
Group by CompanyName

Answer 2

select count(*) as success2 from 表名称 where status='T'
select count(*) as successTF2 from 表名称 where status='TF'
select count(*) as error2 from 表名称 where status='F'追问

一个sql搞定 可以否。

追答

select status,count(*) from 表名称 where status in ('T','TF','F') group by status

本回答被提问者采纳