Advanced Search

Return to Snippet

Revision: 66059
at March 6, 2014 20:41 by marrouchi
Initial Code 
SELECT COUNT(alias.id) FROM (SELECT id, COUNT(id) AS cnt
FROM table
GROUP BY id
HAVING (cnt > 1)) as alias
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Count how many duplicates you have in a table

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Count how many duplicates you have in a table

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL