Mysql过滤SELECT查询结果。

Question

我有以下查询。

SELECT COUNT(id) AS NumResults, race_date AS RaceDate, race_time AS RaceTime
FROM results 
WHere jockeys_claim = 10
GROUP BY race_date DESC, race_time ASC

然后我想过滤掉 NumResults ，因此该表仅显示 NumResults = 1 的结果。感谢您的查看。

Answer 1

使用 HAVING 子句过滤聚合函数的结果(在您的情况下为 COUNT)

SELECT COUNT(id) AS NumResults, race_date AS RaceDate, race_time AS RaceTime
FROM results 
WHere jockeys_claim = 10
GROUP BY race_date, race_time
HAVING COUNT(id) = 1
ORDER BY race_date DESC, race_time ASC