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
- 17663 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / nitin
option b is correct because we can not compare more than one values with single value using '=' operator.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
write a C++ program for booking using constructor and destructor.
What does sksksk mean in text slang?
What makes a language oop?
Can abstract class have normal methods?
• What are the desirable attributes for memory managment?
What is the purpose of enum?
why reinterpret cast is considered dangerous?
What is debug class?what is trace class? What differences are between them? With examples.
What are constructors in oop?
What is encapsulation in oop?
Why do we use encapsulation in oops?
How do you explain polymorphism?
Advantage and disadvantage of routing in telecom sector
Which is better struts or spring?
How do you define social class?
