SQL语句:IFNULL 表达式
SELECT
SUM(IFNULL(XUELIXUEWEI LIKE '%研究生%','0') AND 旗区 = #{旗区}) A,
SUM(IFNULL(XUELIXUEWEI LIKE '%大学%','0') AND 旗区 = #{旗区}) B,
SUM(IFNULL(XUELIXUEWEI LIKE '%本科%','0') AND 旗区 = #{旗区}) C,
SUM(IFNULL(XUELIXUEWEI LIKE '%专%','0') AND 旗区 = #{旗区}) D,
SUM(IFNULL(XUELIXUEWEI LIKE '%高中%' OR XUELIXUEWEI LIKE '%初中%' OR XUELIXUEWEI LIKE '%小学%','0') AND 旗区 = #{旗区}) G
FROM SHOUYE_TONGZHANRENYUANSHUJU