34,576
社区成员
发帖
与我相关
我的任务
分享
select 状态,count(1) from yeezong group by 状态
select count(*) from yeezong
select count(*) from yeezong where 状态='已缴费'
select count(*) from yeezong where 状态<>'已缴费'
select count(*) from yeezong where 状态 is null
create table #(stat varchar(10))
insert # select '已缴费'
insert # select '未缴费'
insert # select null
select count(*) from # where stat = '已缴费'
select count(*) from # where stat <> '已缴费'
select count(*) from #