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
- 14740 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / rupali
Option 2 is correct.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are properties in oop?
What is inheritance in simple words?
What is this pointer in oop?
Why is oop useful?
What are two types of polymorphism?
Which language is pure oop?
State what is encapsulation and friend function?
Will I be able to get a picture in D drive to the c++ program? If so, help me out?
What is constructor overloading in oop?
What is the main feature of oop?
Why is object oriented programming so hard?
How to use CMutex, CSemaphore in VC++ MFC
What is the real time example of inheritance?
How to call a non virtual function in the derived class by using base class pointer
What is Difeerence between List obj=new ArrayList(); and ArrayList obj=new ArrayList()?
