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 are main features of oop?
Write a program to reverse a string using recursive function?
Describe these concepts: Polymorphism, Inheritance and Abstraction.
When not to use object oriented programming?
What are functions in oop?
What is an advantage of polymorphism?
Why do we use encapsulation in oops?
write a program to find 2^n+1 ?
What are the benefits of oop?
Why do we use polymorphism?
What is data binding in oops?
What is a null tree?
What is oops with example?
How long to learn object oriented programming?
Why do we need oop?