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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.