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
- 16110 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / sharmaamitanand
In my knowlenge if i run this query,the subquery is likely
to return more than single rows as resultset as OR condition
is used so 3rd option is likely to be occured.
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
Following are the class specifications: class {int a}; class {int b}; Using friend funtion,calculate the max of two objects and display it.
What is abstract class in oop?
What are oops functions?
i am getting an of the type can not convert int to int *. to overcome this problem what we should do?
Which type does string inherit from?
if i have same function with same number of argument but defined in different files. Now i am adding these two files in a third file and calling this function . which will get called and wht decide the precedence?
Why is encapsulation used?
What are the 3 principles of oop?
What is stream in oop?
What is destructor example?
What is abstraction in oops with example?
officer say me - i am offered to a smoking , then what can you say
How is polymorphism achieved?
What is difference between polymorphism and inheritance?
What is the difference between static polymorphism and dynamic polymorphism?
