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 / rupali
Option 2 is correct.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of polymorphism?
What is the difference between a constructor and a destructor?
Explain the advantages of inheritance.
How oops is better than procedural?
Why is polymorphism needed?
Why is abstraction used?
Get me a number puzzle game-program
What is the types of inheritance?
What is basic concept of oop?
What is abstraction and encapsulation?
Why we use classes in oop?
What are the 3 principles of oop?
Explain the concepts involved in Object Oriented programming.
explain sub-type and sub class? atleast u have differ it into 4 points?
How do you answer polymorphism?