Discussion :: SQL Basics
- The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs
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