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

Can I use a variable condition in a CASE statement?

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 3, rows affected: 7, absolute service time: 0,17 sec 
edit mode |  history 
  
user_name
Is_Customer
became_customer
interactions_before_customer
interactions_after_customer



1
tony
No
NULL
1
0



2
jane
Yes
2016-08-06 12:00:00
2
0



3
john
Yes
2017-01-02 12:00:00
1
1






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development