What will be the output for the below Query
Select 'High' from dual where null = null;
Answers were Sorted based on User's Feedback
Answer / 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 |
Which is better cte or subquery?
Write one update command to update seqno field of a table on the basis of row number.
How can we debug in PL/SQL?
What is the difference between delete, truncate and drop command?
Why are aggregate functions called so?
What is a cursor for loop ?
What are the types of join in sql?
What is before and after trigger?
What is difference between cursor and ref cursor?
what is explain plan?
What is null in pl/sql?
How to call a javascript function from pl sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)