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

option b is correct...

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is abstraction used?

597


Please send ford technologies placement paper 2 my mail id

1646


What is a null tree?

617


Can you name some types of inheritance?

630


Can destructor be overloaded?

588






• What are the desirable attributes for memory managment?

1715


What is Difference Between Inheritance and creating object and getting data? means Class A extends B{ B.getMethod();} (OR) Class A{ b obj=new B(); obj.getMethod(); }

1971


What is destructor in oop?

615


is there any choice in opting subjects like 4 out of 7

1723


What is object in oop?

669


Do you know about multiple inheritance?

632


i am getting an of the type can not convert int to int *. to overcome this problem what we should do?

1826


i=20;k=0; for(j=1;k-i;k+=j<10?4:3) { cout<

1409


What is the full form of oops?

601


Can we create object of interface?

591