这与tombom的答案相同，但是具有SQL Server语法：
SELECt SUM(CASE WHEN CoumntA < 0 THEN 1 ELSE 0 END) AS LessThanZero, SUM(CASE WHEN CoumntA > 0 THEN 1 ELSE 0 END) AS GreaterThanZeroFROM TableA
这与tombom的答案相同，但是具有SQL Server语法：
SELECt SUM(CASE WHEN CoumntA < 0 THEN 1 ELSE 0 END) AS LessThanZero, SUM(CASE WHEN CoumntA > 0 THEN 1 ELSE 0 END) AS GreaterThanZeroFROM TableA
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
