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
- 17290 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / raghavan
Actually the query may return more than one row.
Hence "is" should be used in place of "=".
So the best answer would be the third choice.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
Please send ford technologies placement paper 2 my mail id
explain sub-type and sub class? atleast u have differ it into 4 points?
What is abstraction oop?
What is data binding in oops?
assume the program must insert 4 elements from the key board and then do the following programs.sequential search(search one of the elements),using insertion sort(sort the element) and using selection sort(sort the element).
What is meant by oops concept?
What does and I oop mean?
Is enum a class?
What is polymorphism give a real life example?
to find out the minimum of two integer number of two different classes using friend function
What is class in oop with example?
What is advantage of inheritance?
What is a superclass in oop?
Why is abstraction needed?
What is the types of inheritance?
