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
- 14708 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / r
option b is correct...
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Why do pointers exist?
I have One image (means a group photo ) how to split the faces only from the image?............ please send the answer nagadurgaraju@gmail.com thanks in advace...
what is different between oops and c++
What is the benefit of oop?
What is abstraction in oops with example?
How do you explain polymorphism?
class CTest { public: void someMethod() { int nCount = 0; cout << "This is some method --> " << nCount; } }; int main() { CTest *pctest; pctest->someMethod(); return 0; } It will executes the someMethod() and displays the value too. how is it possible with our creating memory for the class . i think iam not creating object for the class. Thanks in Advance... Prakash
What is the difference between a constructor and a destructor?
What does I oop mean?
Where You Can Use Interface in your Project
What is abstraction example?
Why is there no multiple inheritance?
What is a class oop?
What is oops and its features?
Can main method override?
