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 / 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
What is the use of oops?
write a program to enter a string like"sunil is a good boy and seeking for a job" not more than 10 characters including space in one line,rest characters should b in other line.if the next line starts from in between the previous word,then print whole word to next line.
write a programe to calculate the simple intrest and compund intrest using by function overlading
Plese get me a perfect C++ program for railway/airway reservation with all details.
what is different between oops and c++
What is property in oops?
Explain the advantages of inheritance.
Can we create object of interface?
What do you mean by abstraction?
How Do you Code Composition and Aggregation in C++ ?
Which language is pure oop?
What is methods in oop?
what is the sylabus for priliminaries?
Why do pointers exist?
What is the difference between a mixin and inheritance?