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
- 18018 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / sharmaamitanand
In my knowlenge if i run this query,the subquery is likely
to return more than single rows as resultset as OR condition
is used so 3rd option is likely to be occured.
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
What does no cap mean?
What type of loop is a for loop?
What is meant by multiple inheritance?
What is abstract class in oop?
What is the advantage of oop over procedural language?
What do you mean by abstraction?
How do you use inheritance in unity?
What is pure oop?
IS IT NECESSARY TO INITIALIZE VARIABLE? WHAT IF THE INSTANCE VARIABLE IS DECLARED final ? IS IT NECESSARY TO INITIALIZE THE final VARIABLE AT THE TIME OF THEIR DECLARATION?
Is abstract thinking intelligence?
What do you mean by overloading?
What does and I oop mean?
Why is abstraction used?
Is data hiding and abstraction same?
What does it mean when someone says I oop?
