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
- 17667 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
What are functions in oop?
What is inheritance and how many types of inheritance?
to find out the minimum of two integer number of two different classes using friend function
What is overriding in oop?
Which language is not a true object oriented programming language?
What is constructor overloading in oop?
How to use CMutex, CSemaphore in VC++ MFC
Can private class be inherited?
What is the difference between a constructor and a destructor?
What is the real time example of inheritance?
Why do we use class?
i got a backdoor offer in process global,Bangalore..Can i work with it?
What is oops in simple words?
What is super in oop?
What is polymorphism and example?
