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 / manish

Option 3 is right

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If a=5, b=6, c=7, b+=a%c*2. What is the final value of b?

936


Explain virtual inheritance?

680


What is polymorphism what are the different types of polymorphism?

553


Can you name some types of inheritance?

634


Templates mean

1581






Give two or more real cenario of virtual function and vertual object

1847


What is the difference between a constructor and a destructor?

603


What does and I oop mean?

610


What is encapsulation oop?

568


What are the important components of cohesion?

547


Write a c++ program to display pass and fail for three student using static member function

2801


Why it is called runtime polymorphism?

572


What is a null tree?

620


which feature are not hold visual basic of oop?

1717


I have One image (means a group photo ) how to split the faces only from the image?............ please send the answer nagadurgaraju@gmail.com thanks in advace...

1618