Advanced Search

Return to Snippet

Revision: 57868
at June 13, 2012 06:04 by TheNullByte
Updated Code 
SELECT * 
FROM [tablename]
INNER JOIN (
SELECT COUNT( * ) , [columnOfDuplicates]
FROM [tablename]
GROUP BY [columnOfDuplicates]
HAVING COUNT( * ) >1
) AS t2 ON [tablename].[columnOfDuplicates] = t2.[columnOfDuplicates]

Revision: 57867
at June 13, 2012 03:44 by TheNullByte
Updated Code 
SELECT * 
FROM [tablename]
INNER JOIN (
SELECT COUNT( * ) , [columOfDuplicates]
FROM [tablename]
GROUP BY c1/c2
HAVING COUNT( * ) >1
) AS t2 ON [tablename].[columOfDuplicates] = t2.[columOfDuplicates]

Revision: 57866
at June 13, 2012 03:41 by TheNullByte
Updated Code 
SELECT * 
FROM xxxxx
INNER JOIN (
SELECT COUNT( * ) , [columOfDuplicates]
FROM xxxxx
GROUP BY c1/c2
HAVING COUNT( * ) >1
) AS t2 ON xxxxxx.[columOfDuplicates] = t2.[columOfDuplicates]

Revision: 57865
at June 13, 2012 03:02 by TheNullByte
Initial Code 
SELECT * 
FROM xxxxx
INNER JOIN (
SELECT COUNT( * ) , c1, c2
FROM xxxxx
GROUP BY c1/c2
HAVING COUNT( * ) >1
) AS t2 ON xxxxxx.c1/c2 = t2.c1/c2
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Instead of the standard return of duplicates, this will actually show the rows that are duplicated, making it easier to see the data

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MySQL Select duplicates

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL