select pid,DATE_FORMAT(create_date,'%Y%u') weeks,sum(total) countTotal from table_name
where in_out=2
GROUP BY pid,weeks
order by weeks desc
select pid,DATE_FORMAT(create_date,'%Y%u') weeks,sum(total) countTotal from table_name
where in_out=2
GROUP BY pid,weeks
order by weeks desc
本文标题:SQL:Mysql 按周分组聚合统计
本文链接:https://www.haomeiwen.com/subject/mfljoktx.html
网友评论