Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. What operator tests column for the absence of data?

    2. A.

     EXISTS operator
    B.

     NOT operator
    C.

     IS NULL operator
    D.

     None of these

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    Always use IS NULL to look for NULL values.

    Syntax:

    SELECT "column_name"
    FROM "table_name"
    WHERE "column_name" IS NULL

Write your comments here:

Be The First To Comment