mysql - 可以对 DISTINCT mysqli 查询进行排序吗？

Question

我用这个查询我的数据库:

SELECT DISTINCT type FROM drinks ORDER BY order ASC

我收到此错误消息:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order ASC' at line 1

绝对是 ORDER BY order ASC 打破了它。

Answer 1

使用这个

SELECT DISTINCT type FROM drinks ORDER BY `order` ASC

你也可以用这个

SELECT DISTINCT d.type FROM drinks AS d ORDER BY d.order ASC