mysql报错：Expression #1 of ORDER BY clause is not in SELECT list

报错

SELECT
	DISTINCT n.id,
	n.`status`,
	n.title,
	n.content 
FROM
	notice n
WHERE
	n.STATUS = 2 
ORDER BY
	n.release_time DESC

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xinyuan_server.n.release_time’ which is not in SELECT list; this is incompatible with DISTINCT

解决办法

第一种

 # 去重方式使用 group by 分组去重
SELECT n.id,
               n.`status`,
               n.title,
               n.content
        FROM notice n
                 LEFT JOIN notice_scope ns on ns.notice_id = n.id
        WHERE n.STATUS = 2
          and ns.project_id = '1'
        GROUP BY n.id
        ORDER BY n.release_time DESC

第二种

参考 https://blog.csdn.net/qq_25983579/article/details/104890672

问题原因：
mysql5.7.5及以上版本将sql_mode的ONLY_FULL_GROUP_BY模式默认设置为打开状态，会导致一些错误：

1、我们使用GROUP BY查询时，出现在SELECT字段后面的只能是GROUP
BY后面的分组字段，或使用聚合函数包裹着的字段，否则会报错如下信息： 　　Expression #1 of SELECT list is
not in GROUP BY clause and contains nonaggregated column
‘database.table.column’ which is not functionally dependent on columns
in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by
2、当使用ORDER BY查询时，不能使用SELECT
DISTINCT去重查询。否则会报错如下信息： Expression #1 of ORDER BY clause is not in
SELECT list, references column ‘database.table.column’ which is not in
SELECT list; this is incompatible with DISTINCT