Accenture Interview Questions | SQL query?
Question
What is the result of following query?
select case when null=null then ‘Amit’ else ‘Rahul’ end from dual;
in progress
0
Interview Question
4 years
5 Answers
929 views
Grand Master 0
Answers ( 5 )
The answer will be Rahul because NULL is never equal to NULL.
Rahul
The answer will be Rahul because we cannot equalize NULL with NULL
The answer is ” Rahul” because according to the three-valued logic of SQL, the result of null = null is not true but unknown.
This is often not a problem because SQL generally treats unknown like false when making binary decisions
The answer is “RAHUL” because according to the three-valued logic of SQL, the result of null = null is not true but unknown
This is often not a problem because SQL generally treats unknown like false when making binary decisions