SELECTCASE WHEN null = nullTHEN ‘True’ELSE ‘False’END AS Result;
Loading
Q. What is the result of following query?
4 Answers
Ans :- Null
When we compare the null = null then sql understand it like Unknown but when we return its value in identity then you will get the null as result.
Upendra RajPosted Dec 28, 2023, 6:55 AM
False
Avneesh AryanPosted Oct 26, 2023, 7:16 AM
The result will be 'False'
This is because the comparison 'NULL=NULL' evaluates to 'UNKNOWN', and since there is no specific condation for 'UNKNOWN' in your 'CASE' statement, it falls back to the 'ELSE' clause, which return 'False'
srihari nelapatiPosted Oct 21, 2023, 5:46 PM
False
Ajay KumarPosted Oct 18, 2023, 4:14 AM