Bits and Pieces: MySQL: how to get records with count

Friday, 19 July 2019

SELECT *, count(*) as cc 
FROM manytomany 
GROUP BY aid, bid
HAVING 1 < count(*)
ORDER BY cc DESC