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
- 14588 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / dilip
the answer is b becouse the query the query compares one
row at a time and there is multiple rows generated in
subqueries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do you achieve runtime polymorphism?
what is the sylabus for priliminaries?
What is destructor oops?
What is the diamond problem in inheritance?
Write a program to implement OOPS concepts such as inheritance, polymorphism, friend function, operator overloading?
What is the difference between static polymorphism and dynamic polymorphism?
What does and I oop and sksksk mean?
What are the 3 principles of oop?
What is polymorphism what is it for and how is it used?
what type of questions
How oops is better than procedural?
What is the difference between abstraction and polymorphism?
Why do we use polymorphism?
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).
write knight tour problem which is present in datastructure
