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
- 14695 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / r
Sorry ...frgot explain why it is 2nd option....everyone
explained it right ..but the answer choosen is incorrect...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What makes a language oop?
What is super in oop?
What is for loop and its syntax?
Why do we need oop?
What is overloading and its types?
Templates mean
Why is object oriented programming so hard?
what are the different types of qualifier in java?
What is class and object in oops?
What is polymorphism oop?
What is data binding in oops?
What is polymorphism programming?
How to use CMutex, CSemaphore in VC++ MFC
What is encapsulation in ict?
Why is polymorphism needed?
