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

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

More SQL PLSQL Interview Questions

What are sql functions? Describe the different types of sql functions?

0 Answers  


What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,


How do I start sql from command line?

0 Answers  


Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,


What is data profiling in sql?

0 Answers  






What are the types of SQL Statement?

3 Answers  


What is the difference between left and left outer join?

0 Answers  


What is the difference between a subquery and a join?

0 Answers  


i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  


What is the difference between instead of trigger and after trigger?

0 Answers  


What is record data type?

0 Answers  


Why trigger is used in sql?

0 Answers  


Categories