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
- 14587 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / girish
Final Answer is 'Option 2' . Read option 2 and 3
carefully, u will get to know why 2 is correct.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the point of polymorphism?
What are benefits of oop?
What is super in oop?
Plese get me a perfect C++ program for railway/airway reservation with all details.
write a programe to calculate the simple intrest and compund intrest using by function overlading
What is constructor in oop?
What are the three main types of variables?
2. Give the different notations for the class.\
Which method cannot be overridden?
Why is oop better than procedural?
What is data binding in oops?
What is encapsulation process?
What is encapsulation with real life example?
What is multilevel inheritance?
to find out the minimum of two integer number of two different classes using friend function
