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

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 47
    Comment on it

    missing or unknown data is considered as null values.It indicates that value is not applicable for a set of attributes. NULL Value is different from an empty or zero value
    To test for NULL values we use comparison operators, such as =, <, or <>.

    To select only the records with NULL values we use following syntax:

    SELECT LastName,FirstName,city FROM emp WHERE city IS NULL

    LastName      FirstName       City
    Tomar         mukesh
    Gupta         ayush
    

 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: