MySql 内连接 COUNT>0

Question

如何选择计数>0 的所有行？

“点击次数>0”不起作用。

SELECT b . * , COUNT( a.abfrage_id ) AS  `hits` 
FROM abfragen_ergebnisse a
RIGHT JOIN suchen b ON a.abfrage_id = b.id
WHERE b.id <140
GROUP BY b.id
ORDER BY  `hits` DESC , b.`id` ASC 

Answer 1

您应该使用HAVING :

SELECT b . * , COUNT( a.abfrage_id ) AS  `hits`
FROM abfragen_ergebnisse a
  RIGHT JOIN suchen b ON a.abfrage_id = b.id
WHERE b.id <140
GROUP BY b.id
HAVING `hits` > 0
ORDER BY  `hits` DESC , b.`id` ASC