Cacher is the code snippet organizer for pro developers

SELECT id,title
FROM events
GROUP BY title, 
HAVING COUNT(title) > 1
ORDER BY title;


SELECT  count(title),title
FROM    events e1
WHERE   1 <
(
    SELECT  COUNT(*)
    FROM    events e2
    WHERE   e1.title = e2.title
    
)

GROUP BY title;