Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

How to delete duplicate rows in sql server?

Language: Layout:
View schema
Execution time: 0 sec, rows selected: 2, rows affected: 6, absolute service time: 0,19 sec 
latest |  history 
  
col1
col2
col3
col4
col5
col6
col7



1
john
1
1
1
1
1
1



2
sally
2
2
2
2
2
2






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development