skamitanand


{ City } pune
< Country > india
* Profession * sr sw engg
User No # 66563
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 26
Users Marked my Answers as Wrong # 4
Questions / { skamitanand }
Questions Answers Category Views Company eMail




Answers / { skamitanand }

Question { Zycus Infotech, 14578 }

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

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