What will be the output for the below Query
Select 'High' from dual where null = null;
Answer Posted / rapaka srivani
the answer will be "no rows selected" because in question
we used a word called 'dual'. 'dual' is a default table in
SQL where it doesn't contain data. so the answer will
be 'no rows selected'.
| Is This Answer Correct ? | 20 Yes | 23 No |
Post New Answer View All Answers
what is a constraint? Tell me about its various levels. : Sql dba
What is pivot table in sql?
What is %type in sql?
how to concatenate two character strings? : Sql dba
Explain what is sql*plus?
Is sql a backend language?
Does a join table need a primary key?
What are views in sql?
What is integrity in sql?
what are the join types in tsql? : Transact sql
Is it possible to read/write files to-and-from PL/SQL?
Define a temp table?
What is the requirement of self-join?
Explain what is dbms?
How can you view the errors encountered in a trigger?