Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

  2. A.

     Hi

    B.

     FLASE

    C.

     TRUE

    D.

     Nothing

    View Answer

    Workspace

    Answer : Option D

    Explanation :

    Since Null is not a member of any data domain, it is not considered a "value", but rather a marker (or placeholder) indicating the absence the value. Because of this, comparisons with Null can never result in either True or False, but always in a third logical result,as Unknown. So, comparing NULL with NULL results to NULL.


Be The First To Comment