You attempt to query the data base with this command:
SELECT name, salary FROM employee WHERE salary=(SELECT
salary FROM employee WHERE last name='Wagner' OR dept no=233)
Choose most appropriate option from the following:
1)Sub-queries are not allowed in the where clause.
2)a multiple row sub-query used with a single row comparison
operator.
3)a single row query is used with a multiple row comparison
operator.
Answer Posted / manish
Option 3 is right
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What are the 5 oop principles?
What is abstraction and encapsulation?
Why do we use oops?
What are oops functions?
write knight tour problem which is present in datastructure
IS IT NECESSARY TO INITIALIZE VARIABLE? WHAT IF THE INSTANCE VARIABLE IS DECLARED final ? IS IT NECESSARY TO INITIALIZE THE final VARIABLE AT THE TIME OF THEIR DECLARATION?
when to use 'mutable' keyword and when to use 'const cast' in c++
What is the difference between encapsulation and polymorphism?
What is polymorphism give a real life example?
What does oop mean in snapchat?
What is polymorphism programming?
What is class and object in oops?
Can abstract class have normal methods?
Is html an oop?
Why is it so that we can have virtual constructors but we cannot have virtual destructors?