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.
Answer Posted / rupali
Option 2 is correct.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
i am getting an of the type can not convert int to int *. to overcome this problem what we should do?
What is variable example?
Who invented oop?
what are the ways in which a constructors can be called?
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 a program to implement OOPS concepts such as inheritance, polymorphism, friend function, operator overloading?
Give two or more real cenario of virtual function and vertual object
What is polymorphism oop?
What do you mean by Encapsulation?
How to hide the base class functionality in Inheritance?
What are oops methods?
What is constructor in oop?
Why is polymorphism important in oop?
Why do we need oop?
is there any choice in opting subjects like 4 out of 7