题解 | 查询单日多次下订单的用户信息？

select date(order_time) as order_date, o.user_id, count(order_id) as order_nums, vip
from order_tb o
left join uservip_tb u on o.user_id = u.user_id
group by o.user_id , date(order_time)
having count(o.user_id) > 1
order by order_nums desc

group by A, B 表示所有在A和B上取值完全相同的行会分到同一组

date()表示提取日期部分 e.g. date('2025-01-01 15:30:00') → 2025-01-01

year()表示提取年份 e.g. year('2025-01-01 15:30:00') → 2025

month()以此类推

day()以此类推

time()表示提取时间部分 e.g. time('2025-01-01 15:30:00') → 15:30:00