Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • IFNULL Function

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 524
    Comment on it

    The IFNULL( ) function is available in MySQL, and not in SQL Server or Oracle. This function takes two arguments.

     

     

    If the first argument is not NULL, the function returns the first argument. Otherwise, the second argument is returned.

     

     

    This function is commonly used to replace NULL value with another value. It is similar to the NVL function in Oracle and the ISNULL Function in SQL Server.

     

     

     

     

    So in this table many NULL values are present that needs to be identified .

     

      SELECT Count(IFNULL(EmpMiddleName)) FROM Employee;

     

     

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: