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.
- 10 Answers
- 14690 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / manish
Option 3 is right
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is the point of oop?
What is the difference between a mixin and inheritance?
I have One image (means a group photo ) how to split the faces only from the image?............ please send the answer nagadurgaraju@gmail.com thanks in advace...
Why do we use polymorphism?
What is abstraction in oop?
when to use 'mutable' keyword and when to use 'const cast' in c++
Can bst contain duplicates?
How do you define social class?
What is the oops and benefits of oops programming?
What is pointer in oop?
What is data binding in oops?
There are two base class B1,B2 and there is one class D which is derived from both classes, Explain the flow of calling constructors and destructors when an object of derived class is instantiated.
When not to use object oriented programming?
What is encapsulation selenium?
What is the types of inheritance?
