Examveda
Examveda

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

A. Hi

B. FLASE

C. TRUE

D. Nothing

Answer: Option D

Solution(By Examveda Team)

The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; outputs Nothing.

In SQL, NULL represents an unknown or missing value. When comparing NULL to NULL using the = operator, the result is neither TRUE nor FALSE; it's unknown. Therefore, the condition NULL = NULL doesn't evaluate to TRUE, and the row is not selected. Hence, the query returns no results, which can be represented as Nothing.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Related Questions on Sql Miscellaneous