/ Published in: SQL
                    
                                        Checking for null value and assigns a default value if the field is null
                
                            
                                Expand |
                                Embed | Plain Text
                            
                        
                        Copy this code and paste it in your HTML
 SELECT COALESCE(age,0) FROM employee
Comments
                    Subscribe to comments
                
                