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 / 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 overriding in oop?
write a programe to calculate the simple intrest and compund intrest using by function overlading
What is encapsulation and abstraction? How are they implemented in C++?
Write a program to sort the number with different sorts in one program ??
What is the importance of oop?
There are two base class B1,B2 and there is one class D which is derived from both classes, Explain the flow of calling constructors and destructors when an object of derived class is instantiated.
Why is static class not inherited?
What is difference between data abstraction and encapsulation?
#include
Please send ford technologies placement paper 2 my mail id
What is destructor in oop?
2. Give the different notations for the class.\
What are the three main types of variables?
write string class as your own class in java without using any built-in function
What is the purpose of polymorphism?