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
- 14622 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / sharmaamitanand
In my knowlenge if i run this query,the subquery is likely
to return more than single rows as resultset as OR condition
is used so 3rd option is likely to be occured.
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
What is coupling in oops?
What is constructor overloading in oop?
What are the 3 principles of oop?
What is the benefit of oop?
Where You Can Use Interface in your Project
What is object in oops?
Is react oop?
Why is static class not inherited?
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.
Why do we use oops?
what are the ways in which a constructors can be called?
What is a superclass in oop?
Are polymorphisms mutations?
Why do pointers exist?
Can abstract class have normal methods?
