mysql - 使用 Group By 时重复值

Question

SELECT location,special,price FROM `tickets` 
WHERE event = 'food' GROUP BY location

标签： mysql

Answer 1

如果您希望行中没有重复的结果，您可以只选择不同的结果集。

SELECT DISTINCT location,special,price FROM tickets WHERE event = 'food' GROUP BY location