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 / manish
Option 3 is right
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What does and I oop mean?
What are the benefits of oop?
What is and I oop mean?
Explain the advantages of inheritance.
Write a java applet that computes and displays the squares of values between 25 and 1 inclusive and displays them in a TextArea box
What does oop mean in snapchat?
What is persistence in oop?
Prepare me a program for the animation of train
What is difference between oop and pop?
How to use CMutex, CSemaphore in VC++ MFC
What is multilevel inheritance in oop?
What is difference between pop and oop?
Why is oop better than procedural?
What does enum stand for?
Can a varargs method be overloaded?