<select id="findTendencyCountByCategoryIdAndCountTime" resultMap="BaseResultMap" > select date_format(count_time, '%Y-%m-%d') as countTime,sum(resource_num) as totalResourceNum from enterprise_sale_count where category_id = #{categoryId} <![CDATA[ AND count_time >= #{startTime} ]]> <![CDATA[ AND count_time <= #{endTime} ]]> group by count_time ORDER BY count_time </select>
这里一定要取别名
最新推荐文章于 2022-01-27 22:35:21 发布