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

  • IFNULL Function

    @HIMANSHU
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 573
    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;

     

     

    mysql
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: