<

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.