from 表名 where date_format(日期,'%Y-%m-%d')>=DATE_FORMAT(DATE_ADD(sysdate(),INTERVAL -6 day),'%Y-%m-%d')
group by date_format(日期,'%Y-%m-%d')
你看是这个意思吗
表名和日期字段换一下
select user_id,sum(count_1),sum(count_2),count_1,create_timefrom table_name a
group by user_id
having count_1 >= all
(select count_1
from table_name
where a.user_id=user_id and a.create_time=create_time)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)