select count(p.id) AS idNum, max(p.aa) as aa, max(p.bb) as bb, max(p.cc) as cc, max(p.dd) as dd, from 表名 p where p.is_del !=1 <if test="pageBo.xxx!=null and pageBo.xxx!=''"> and p.xxx LIKE CONCAT(CONCAT('%', #{pageBo.xxx}), '%') </if> <if test="pageBo.startDate != null and pageBo.startDate != '' and pageBo.endDate != null and pageBo.endDate != '' "> and DATE_FORMAT(p.create_time, '%Y-%m-%d') <![CDATA[<=]]> #{pageBo.startDate} and DATE_FORMAT(p.create_time, '%Y-%m-%d') <![CDATA[>=]]> #{pageBo.endDate} </if> GROUP BY aa ORDER BY create_time