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
- 16104 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / nitin
option b is correct because we can not compare more than one values with single value using '=' operator.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what's the basic's in dot net
What do you mean by abstraction?
What language is oop?
What is difference between multiple inheritance and multilevel inheritance?
Plese get me a perfect C++ program for railway/airway reservation with all details.
Why do we use polymorphism in oops?
Can an interface inherit a class?
What is object in oop with example?
What does and I oop mean?
What is Difeerence between List obj=new ArrayList(); and ArrayList obj=new ArrayList()?
What is encapsulation with real life example?
can inline function declare in private part of class?
Why do we need oop?
What are the benefits of oop?
What is and I oop mean?
