日期:2014-05-18 浏览次数:20452 次
select A,count(1) as '记录条数' from TB group by A ------解决方案-------------------- 查空值条数:select count(*) from S where isnull(A, '')=''查询每个值有多少条记录:select A, count(*) from S where isnull(A, '')<>'' group by A