1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / abhishek6555

Answers were Sorted based on User's Feedback



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

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

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

Answer / jjjjjj

the answer id 'high'

Is This Answer Correct ?    5 Yes 17 No

Post New Answer

More SQL PLSQL Interview Questions

What will you get by the cursor attribute sql%notfound?

0 Answers  

How many triggers can be applied to a table?

0 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

What are the sql versions?

0 Answers  

What is the difference between function and procedure in pl/sql?

0 Answers  




what are numeric data types? : Sql dba

0 Answers  

Does truncate release storage space?

0 Answers  

When to use inner join and left join?

0 Answers  

explain mysql aggregate functions. : Sql dba

0 Answers  

Is null operator in sql?

0 Answers  

Can a primary key be a foreign key?

0 Answers  

How to fix oracle error ora-00942: table or view does not exist

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories