What will be the output for the below Query
Select 'High' from dual where null = null;
Answers were Sorted based on User's Feedback
Answer / shijo
The Answer will always be null, since you never can equate a
NULL to another NULL. if the query was "Select 'High' from
dual where null IS null;" The answer would have been "High"
Is This Answer Correct ? | 61 Yes | 19 No |
Answer / abhishek6555
The answer will be no rows selected as null = null will be
false condition and the where condition will become false.
Is This Answer Correct ? | 14 Yes | 7 No |
Answer / amedela chandra sekhar
The correct answer is
SQL> Select 'High' from dual where null = null;
no rows selected
Chandu
chandumba2005@gmai.com
Is This Answer Correct ? | 9 Yes | 5 No |
Answer / kart
since the query is syntaxically correct
the output will be
no rows selected;
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / vijay repe
Query will give o/p as 'High' if condition u put as null is
null insteat of null = null.
It considers as false where condition same as 1=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sri
two nulls are not equal
so the answer is no rows selected.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / zia
Syntax is correct, but result will show only column heading without data as 'HIGH'.
Is This Answer Correct ? | 2 Yes | 3 No |
How do you determine the current isolation level? : Transact sql
What is the use of sqlerrd 3?
What are the data types allowed in a table?
What are the ddl commands?
What are the operators in sql?
Is sql procedural language?
Can a table have two primary keys?
What are Global Temporary tables
What is faster join or subquery?
What are the sql versions?
what is schema? : Sql dba
What are different types of functions in sql?