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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlite format?

622


What is a call statement? Explain with an example.

539


what is a constraint? Tell me about its various levels. : Sql dba

554


what is transaction? : Sql dba

524


what is datawarehouse? : Sql dba

561






When should I use nosql database?

544


How many disk partitions should I have?

542


what are wild cards used in database for pattern matching ? : Sql dba

537


Enlist the advantages of sql.

561


What does a pl/sql package consist of?

508


What is rtm stands for?

573


What is the largest value that can be stored in a byte data field?

515


What found sql?

516


What do you mean by field in sql?

525


how to create a test table in your mysql server? : Sql dba

486