Mysql - 按月日期显示行组

Question

我有一个包含帖子的表格，我想按月份和年份对数据进行排序，并显示所有行数据。例如，如果一个月有 10 行，则它们都应该是可见的。

对于帖子计数，我目前使用此查询:

SELECT  YEAR(created_at), MONTHNAME(created_at) ,Count(id)
FROM `posts` 
GROUP BY YEAR(created_at),MONTH(created_at);

结果是:

2013    November    4
2013    December    5
2014    January     2
2014    February    1
2014    March   1
2014    November    15

但是，我想将以下内容作为我的输出:

2013 November Some Post
2013 November Some Other Post
2013 December Some Other Post 2
2014 January First Post
2014 January Second Post

Answer 1

您实际上并不想使用GROUP BY!

相反，您想使用 ORDER BY:

SELECT  YEAR(created_at), MONTHNAME(created_at), name
FROM `posts` 
ORDER BY YEAR(created_at), MONTH(created_at);

我假设您的帖子名称在 name 列中。