mysql - 排序依据在分组依据之前

Question

这个问题已经有答案了:

GROUP_CONCAT ORDER BY (5 个回答)

已关闭 8 年前。

我需要提取几千条记录的一些数据，但在对结果进行排序时遇到问题。

SELECT IdCode, GROUP_CONCAT(' ',CONCAT(MONTHNAME(ei.StartDatetime),' ',YEAR(ei.StartDatetime))) 
FROM exclusion_import_data eid JOIN exclusion_import ei ON ei.ImportId = eid.ImportId 
WHERE ( IdCode IN ( '84277', '253533' ))  
GROUP BY IdCode 
ORDER BY RecordId ASC;

基本上，我想查看我们的系统中出现了哪些月份的特定记录。

253533 May 2013, November 2013, December 2013, January 2014, February 2014, March 2014, April 2014, May 2014, June 2014, August 2014, October 2013, September 2013, June 2013, July 2013, May 2013, August 2013 84277 September 2013, April 2014, May 2013, May 2014, June 2014, May 2013, March 2014, June 2013, February 2014, January 2014, July 2013, December 2013, November 2013, August 2013, October 2013, August 2014

上面的查询返回正确的月份，由 idCode 分隔，但月份的顺序都是乱序的。

如何在对记录进行分组之前对其进行排序？

Answer 1

使用group_concat()中的order by选项:

SELECT IdCode,
       GROUP_CONCAT(' ', CONCAT(MONTHNAME(ei.StartDatetime),' ',YEAR(ei.StartDatetime))
                    ORDER BY ei.StartDatetime)
FROM exclusion_import_data eid JOIN
     exclusion_import ei
     ON ei.ImportId = eid.ImportId 
WHERE ( IdCode IN ( '84277', '253533' ))
GROUP BY IdCode 
ORDER BY RecordId ASC;