Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17666 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / raghavan
Actually the query may return more than one row.
Hence "is" should be used in place of "=".
So the best answer would be the third choice.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What is class and object with example?
What is object in oops?
Get me a number puzzle game-program
What does oop mean in snapchat?
What is this pointer in oop?
what are the different types of qualifier in java?
write a C++ program for booking using constructor and destructor.
What is abstract class in oops?
Who invented oop?
What does enum stand for?
2. Give the different notations for the class.\
Give an example where we have to specifically use C programming language and C++ programming language cannot be used?
What is overriding vs overloading?
What is polymorphism in oops with example?
Explain the advantages of inheritance.
