IS Operator

     

  • This operator enables the user to compare NULL VALUES

    •  

     

     

     

    Q: Write a Query to retrieve data from SALES table where QUANTITY is NULL?

    Select item,Quantity from sales where Quantity is null

     

    IS NOT NULL Operator:

     

     

    Q: Write a Query to retrieve data from SALES table where QUANTITY is NOT NULL?

    Select item,Quantity from sales where Quantity is not null