摘要：
select count( case when status='1' then number1 end) as '检查不及格', count(case when status='2' then number1 end) as '终止作废', sum( case when status='3' then number2 end) as '遗失作废' from table1 阅读全文
posted @ 2011-01-21 18:51
kevin_20131022
阅读(232)
评论(0)
推荐(0)
浙公网安备 33010602011771号