Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 18014 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / raghavan
Actually the query may return more than one row.
Hence "is" should be used in place of "=".
So the best answer would be the third choice.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What is inheritance and how many types of inheritance?
What are functions in oop?
What is inheritance in simple words?
What is class and object in oops?
What is coupling in oop?
What is meant by oops concept?
Can private class be inherited?
How to hide the base class functionality in Inheritance?
What are the benefits of oop?
What is class and example?
Why do while loop is used?
What is a null tree?
Why is polymorphism needed?
What are the 3 principles of oop?
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?
