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

How to select the first id of duplicate records with SQL

Language: Layout:
View schema
Execution time: 0 sec, rows selected: 5, rows affected: 0, absolute service time: 0,17 sec 
edit mode |  history 
  
ID
VatNumber
Name
rid



1
3
BE10128292
Microsoft
2



2
5
BE99292200
Google
2





  
ID
VatNumber
Name
rid



1
1
BE10128292
Microsoft
1



2
2
BE99292200
Google
1



3
4
BE99292200
Some other company
1






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development