Select All Records With Duplicates

Photo of Mike Dalisay
Modified Tuesday, September 27, 2011
by - @ninjazhai
I wanted to select all records with duplicate session numbers (session_number) from my forms table so I'll know if there are error of duplicate entries. I'm using MySQL Database.

Select All Records With Duplicates
Select All Records With Duplicates

Here's a solution I found:

SELECT session_number
FROM forms
GROUP BY session_number
HAVING COUNT( session_number) > 1


SELECT session_number
-I'm just selecting session_number

FROM forms
-I'm selecting records from forms table.

GROUP BY session_number
-This will group all the session_number.

HAVING COUNT(session_number) > 1
-After grouping the session numbers, we will count records with that group's session number. If it is greater than 1, it means it has duplicates, so it will be selected.

That's it! :)
For FREE programming tutorials, click the red button below and subscribe! :)
Thanks for the comments!
"First do it, then do it right, then do it better."
~ Addy Osmani
"Talk is cheap. Show me the code."
~ Linus Torvalds
Let's Stay Connected!
g+ r
Android app on Google Play
© 2011-2014 The Code Of A Ninja. All rights reserved. Proudly Powered by Google Blogger. Images, logos, marks or names mentioned herein are the property of their respective owners.