oracle 使用group by+order by ，模糊查询，时间区间查询笔记

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