紫苏水釉吧 关注:4贴子:143
  • 0回复贴,共1

一条sql语句返回多个count值 [

只看楼主收藏回复

select
count(case when type='01' then 1 else null end) aCount,
count(case when type='02' then 1 else null end) bCount from tblA


IP属地:江苏1楼2014-05-09 11:50回复