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
- 14590 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / vicky
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.
4)logical aparatous are not allowed in where clause .
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Templates mean
What is the difference between procedural programming and oops?
2. Give the different notations for the class.\
What is encapsulation with example?
Why do we use inheritance?
Why do we use polymorphism?
What is ambiguity in inheritance?
Is abstract thinking intelligence?
Write a c++ program to display pass and fail for three student using static member function
Can destructor be overloaded?
What is the difference between a mixin and inheritance?
Get me an image implementation program.
How do you define social class?
class type to basic type conversion
