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

Group more records based on values

Language: Layout:
absolute service time: 0,36 sec 
edit mode |  history 
  
contract_nr
CASE 
          WHEN SUM(id_supplier IS NOT NULL) + SUM(id_seller IS NOT NULL) > 1 THEN 'category1'
          WHEN SUM(id_vendor IS NOT NULL) THEN 'category2'
          ELSE 'N/A'
       END



1
1
category1



2
2
category2



3
3
category1






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development