Question

sql server中 如何根据某列的数值来分组？

例如 把一张表中 A列为空和不为空的分组显示出来

Answer 1

select 'null' as fName,count(b) from test where A is null
union all
select 'not null' as fName,count(b) from test where A is not null

Answer 2

select A,count(A) as '条数' from tableName group by A

Answer 3

用is null或者is not null子句。

Answer 4

SELECT A AS 为空 FROM [表] WHERE A=""

Answer 5

SQL Server数据中运算符与表达式