条件选择case

SELECT COUNT(*),count(CASE b.AUTHORITY WHEN ‘addAsmAccessControlList‘ THEN ‘1‘ ELSE NULL END) as auth FROM TM_SEAT_MAINTAIN_GROUP_AUTHORITY b
INNER JOIN TM_SEAT_MAINTAIN_TOOL_USER a ON a.USER_GROUP = b.USER_GROUP and a.MAINTAIN_TOOL_USER=‘tode‘ GROUP BY MAINTAIN_TOOL_USER

条件选择case

原文：http://www.cnblogs.com/fushou/p/7380422.html