前两天在网上找“case when”用法时看到的一篇很好的文章，分享一下1、WHEN THENWHEN THENELSEEND--------------  select count(*) as ct , CASE  WHEN (Pro_state= 1) THEN 待审  WHEN (Pro_state= 2) THEN 已审  WHEN (Pro_state= 3) THEN