QuePID Posted July 22, 2010 Share Posted July 22, 2010 Hi, I want to display the rows that contain duplicate values within a field of a specific table. I am currently using the following query: SELECT iknew.*, COUNT(*) FROM iknew GROUP BY Accession HAVING COUNT(*) > 1 The output of this query only shows one row per found duplicate not every row that contains duplicates (minimum of 2 rows per duplication). How can I display every single row to which duplication occurs within the field? Link to comment https://forums.phpfreaks.com/topic/208560-displaying-duplicates-within-a-column/ Share on other sites More sharing options...
premiso Posted July 22, 2010 Share Posted July 22, 2010 It seems duplicating stuff is in your nature. Please do not repost the same question. Duplicate of: http://www.phpfreaks.com/forums/index.php/topic,305128.0.html Link to comment https://forums.phpfreaks.com/topic/208560-displaying-duplicates-within-a-column/#findComment-1089667 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.