The answer will be no rows selected as null = null will be false conditio

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

Question Posted / abhishek6555

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is data control language?

979

Why stored procedures are faster than query?

1019

How do you clear the screen in sql?

1064

What does the sign mean in sql?

981

How does sql*loader handles newline characters in a record? : aql loader

1035

What is the difference between numeric and autonumber?

985

Does pl sql work in mysql?

964

What is string join?

969

What are the two types of exceptions in pl/sql?

1043

Why use subqueries instead of joins?

1071

explain advantages of myisam over innodb? : Sql dba

1060

What is a left join?

947

Can we use rowid as primary key?

981

What is sql profiling in oracle?

1052

can a stored procedure call itself or recursive stored procedure? : Sql dba

1018