Advanced Search

Return to Snippet

Revision: 29923
at August 5, 2010 05:39 by lance
Initial Code 
SELECT COUNT(TABLE_ID), TABLE_ID 
FROM TABLE
group by TABLE_ID
having count(TABLE_ID)>1
order by TABLE_ID
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Find duplicate records in table

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL