MySQL按天分组，日期时间混合不同月份的相同日期 [英] MySQL group by day with datetime mixing same dates from different months

问题描述

我正在尝试将同一天的帖子分组，问题是 2/20 与 3/20 (20 = 20) 分组

I'm trying to group posts from same day, the problem is that 2/20 gets grouped with 3/20 (20 = 20)

如何解决这个问题?

这是我当前的代码:

select day(Date), count(*) from Posts WHERE shopID != '' group by shopID, day(Date)

推荐答案

您需要按每个可能不同的部分进行分组.因此，根据查询的范围添加 MONTH(Date) 甚至 YEAR(Date).

You need to group by every piece that might be different. So add MONTH(Date) and even YEAR(Date) depending on the scope of your query.

select DAY(Date), count(*) from Posts WHERE shopID != '' group by shopID, YEAR(Date), MONTH(Date), DAY(Date)

这篇关于MySQL按天分组，日期时间混合不同月份的相同日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！