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 / r
Sorry ...frgot explain why it is 2nd option....everyone
explained it right ..but the answer choosen is incorrect...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is object in oop?
What is overriding in oop?
What is basic concept of oop?
Can abstract class have normal methods?
What is pointer in oop?
What is oops with example?
They started with the brief introduction followed by few basic C++ questions on polumorphism, inheritance and then virtual functions. What is polymorphims? How you will access polymorphic functions in C? How virtual function mechanism works?
What are functions in oop?
How do you achieve runtime polymorphism?
What is polymorphism and example?
Explain virtual inheritance?
Which type does string inherit from?
Can a destructor be called directly?
What is polymorphism and its types?
What is persistence in oop?