ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

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

Answer & Solution
Correct Answer: Option D
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.