What will be the output for the below Query Select 'High' from dual w

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

What will be the output for the below Query
Select 'High' from dual where null = null;

Question Posted / abhishek6555

12 Answers
31299 Views
Infosys, Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What will be the output for the below Query Select 'High' from dual where null = null;..

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

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / binita

No rows selected

Is This Answer Correct ?

23 Yes

4 No

What will be the output for the below Query Select 'High' from dual where null = null;..

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

What will be the output for the below Query Select 'High' from dual where null = null;..

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

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / kart

since the query is syntaxically correct
the output will be

no rows selected;

Is This Answer Correct ?

3 Yes

3 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / ashok

no rows selected

Is This Answer Correct ?

0 Yes

0 No

What will be the output for the below Query Select 'High' from dual where null = null;..

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

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / sri

two nulls are not equal
so the answer is no rows selected.

Is This Answer Correct ?

0 Yes

0 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / prashant yadav

No row select

Is This Answer Correct ?

2 Yes

3 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / zia

Syntax is correct, but result will show only column heading without data as 'HIGH'.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer