Advanced Search

Return to Snippet

Revision: 48784
at July 9, 2011 00:21 by xavsio4
Initial Code 
select fields, fields, ROW_NUMBER OVER (PARTITION primary key(s) order by...) seq
FROM table WHERE condition
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Strategy to identify duplicates in an ETL context (for example)

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL