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
- 14685 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
Prepare me a program for the animation of train
What is class and example?
What is a function in oop?
How to call a non virtual function in the derived class by using base class pointer
What is the real life example of polymorphism?
What are the 5 oop principles?
What does it mean when someone says I oop?
write a program to find 2 power of a 5digit number with out using big int and exponent ?
How many human genes are polymorphic?
Why do we use polymorphism in oops?
What is abstraction in oop with example?
What is encapsulation in ict?
Why is polymorphism used?
Can destructor be overloaded?
What is for loop and its syntax?
