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 the difference between sql and t sql?
What are the query optimization techniques?
how many sql dml commands are supported by 'mysql'? : Sql dba
What are all types of user defined functions?
Difference between truncate, delete and drop commands?
What's the difference between a primary key and a clustered index?
What are the advantages of pl sql?
What are sql functions? Describe the different types of sql functions?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Can we insert delete data in view?
What does trigger mean in slang?
What is db journal file?
how to create a new table by selecting rows from another table in mysql? : Sql dba
How do rank () and dense_rank () differ?
can sql servers linked to other servers like oracle? : Sql dba