Мы в настоящее время используем броски C-стиля везде. Я спросил другой вопрос о кастинге , и я теперь вижу преимущество использования static_cast вместо этого, если ни по какой другой причине, чем он "greppable" (мне нравится этот термин). Я, вероятно, начну использовать это.
мне не нравится стиль C++; это смотрит совсем как вызов функции.
SELECT *, count(*) as cc
FROM manytomany
GROUP BY aid, bid
HAVING 1 < count(*)
ORDER BY cc DESC
You use the having clause.
SELECT *, count(*) as cc
FROM manytomany
GROUP BY aid, bid
HAVING count(*) > 1
ORDER BY cc DESC
You need a HAVING clause, for example:
SELECT *, count(*) as cc
FROM manytomany
GROUP BY aid, bid
HAVING COUNT(*) > 1
ORDER BY cc DESC
Here's some background.
SELECT *, count(*) as cc
FROM manytomany
GROUP BY aid, bid
HAVING cc>1
ORDER BY cc DESC
The HAVING
clause
SELECT *, count(*) as cc
FROM manytomany
GROUP BY aid, bid
HAVING cc > 1
ORDER BY cc DESC
SELECT *, count(*) as cc
FROM manytomany
GROUP BY aid, bid
HAVING COUNT(*) > 1
ORDER BY cc DESC
I don't use MySQL, but it should support HAVING -it has been around for along time.