我有一个表A,表A有一个字段SCORE,在SCORE字段中的记录要么等于0,要么不等于0。 我想请教大家,怎样用一条SQL语句显示出等于0记录有多少条和不等于0记录有多少条? select 不等于0的条数=sum(case when score<>0 then 1 else 0 end), 等于0的条数=sum(case when score=0 then 1 else 0 end) from 表名
等于0 select * from tb where SCORE=0不等于0 select * from tb where isnull(SCORE,1)<>0
SELECT SUM(CASE SCORE WHEN 0 THEN 1 ELSE 0 END) AS 等于0, SUM(CASE SCORE WHEN 0 THEN 0 ELSE 1 END) AS 不等于0 FROM yourTable
我想请教大家,怎样用一条SQL语句显示出等于0记录有多少条和不等于0记录有多少条?
select 不等于0的条数=sum(case when score<>0 then 1 else 0 end),
等于0的条数=sum(case when score=0 then 1 else 0 end)
from 表名
select * from tb where SCORE=0不等于0
select * from tb where isnull(SCORE,1)<>0
SUM(CASE SCORE WHEN 0 THEN 0 ELSE 1 END) AS 不等于0
FROM yourTable