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
- 16153 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / dilip
the answer is b becouse the query the query compares one
row at a time and there is multiple rows generated in
subqueries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why is oop better than procedural?
What is the difference between procedural programming and oops?
How long to learn object oriented programming?
What is abstract class in oop?
what is graphics
When not to use object oriented programming?
What is polymorphism and its types?
What are the components of marker interface?
What polymorphism means?
write a programe to calculate the simple intrest and compund intrest using by function overlading
They started with the brief introduction followed by few basic C++ questions on polumorphism, inheritance and then virtual functions. What is polymorphims? How you will access polymorphic functions in C? How virtual function mechanism works?
What are oops functions?
What is the main purpose of inheritance law?
What is data binding in oops?
How to use CMutex, CSemaphore in VC++ MFC
