首页 > 其他 > 详细

单表count 多个字段 ,按条件统计多个字段的数量

时间:2021-01-14 22:21:22      阅读:55      评论:0      收藏:0      [点我收藏+]

<select id="listMarketingActivities"
resultType="com.yilihuo.cloud.service.shop.manager.dto.api.storedata.MarketingActivitiesResultDto">
select
activity.member_id as memberId,
SUM(CASE WHEN (date_format(r.last_order_date,‘%Y-%m-%d‘) BETWEEN #{paramDto.beginDate}
AND #{paramDto.endDate}) THEN 1 ELSE 0 END) AS completeCustomerCount,
sum(case when activity.id) as weekTotalPlays
from store_manage_activity activity
where activity.activity_type = #{activityType}
<![CDATA[
and date_sub(date_format(#{date},‘%Y-%m-%d %H:%i:%s‘), INTERVAL 30 DAY) <= date(activity.activity_time)
and #{date} > date(activity.activity_time)
]]>
and activity.member_id in
<foreach collection="memberIdList" item="memberId" open="(" separator="," close=")">
#{memberId}
</foreach>
group by activity.member_id
</select>

单表count 多个字段 ,按条件统计多个字段的数量

原文:https://www.cnblogs.com/onlyzhangmeng/p/14279103.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!