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
Why we use classes in oop?
program for insertion ,deletion,sorting in double link list
Why do we use class?
What is abstraction in oops with example?
What is encapsulation and abstraction? How are they implemented in C++?
Whats is abstraction in oops?
What is difference between polymorphism and inheritance?
How long to learn object oriented programming?
Why is static class not inherited?
What is a class in oop?
How do you explain polymorphism?
What is the highest level of cohesion?
what type of questions
Which language is pure oop?
What is a superclass in oop?