xfy18317776108的博客

oracle与mysql不同，GROUP BY必须要跟select查询的所有列（除了聚合函数外） 例如： SELECT TO_DATE(EVENTTIME) as dateTime ,OPNO as siteNum, count(*) as totalCapacity FROM tblusercapacity <where> <if test="date != null"&g...