<

SQL SELECT NULL

There can be two conditions:


  • Where SQL is NULL

  • Where SQL is NOT NULL


  • Where SQL is NULL:



    Syntax

    
    SELECT * FROM table_name 
    WHERE colum_name IS NULL  
    
    


    Where SQL is NOT NULL:



    Syntax

    
    SELECT * FROM table_name 
    WHERE colum_name IS NOT NULL  
    
    















    © copyright 2017-2022 Completedone pvt ltd.