Select All Records With Duplicates
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 Here's a solution I found: SELECT session_numberFROM formsGROUP BY session_numberHAVING COUNT( session_number) > 1 Explanation: SELECT session_number-I'm just selecting session_number FROM […]