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.
Answer Posted / manish
Option 3 is right
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is the renewal class?
What is encapsulation with real life example?
i got a backdoor offer in process global,Bangalore..Can i work with it?
What is encapsulation c#?
What is debug class?what is trace class? What differences are between them? With examples.
How do you answer polymorphism?
Which is better struts or spring?
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 does and I oop mean in text?
Can private class be inherited?
Prepare me a program for the animation of train
what are the ways in which a constructors can be called?
design a c++ class for the chess board,provide a c++ class definition for such class(only class definition is required)
What is an interface in oop?
What are properties in oop?