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 / girish
Final Answer is 'Option 2' . Read option 2 and 3
carefully, u will get to know why 2 is correct.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do we need polymorphism in c#?
What is a class oop?
What is polymorphism programming?
How does polymorphism work?
What is methods in oop?
What is the example of polymorphism?
write a program that takes input in digits and display the result in words from 1 to 1000
What are main features of oop?
Give an example where we have to specifically use C programming language and C++ programming language cannot be used?
What is encapsulation with example?
How do you use inheritance in unity?
What is polymorphism in oop example?
What is a function in oop?
What is and I oop mean?
How Do you Code Composition and Aggregation in C++ ?