Categories
MySQL

MySQL select duplicates

SELECT * 
FROM table_name a
WHERE EXISTS (

SELECT 1 
FROM table_name b
WHERE b.name = a.name
LIMIT 1 , 1
)
ORDER BY name ASC 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.