option b is correct because we can not compare more than one values with si

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.

Question Posted / nitin

10 Answers
18016 Views
Zycus Infotech, I also Faced
E-Mail Answers

Answer Posted / nitin

option b is correct because we can not compare more than one values with single value using '=' operator.

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is encapsulation oop?

1107

hi, this is raju,iam studying b.tech 2nd year,iam want know about group1 and group2 details, and we can studying without going to any instutions? please help me.

2017

Which is better struts or spring?

1117

What is constructor overloading in oop?

1182

What is destructor oops?

1153

Is abstract thinking intelligence?

1110

Can abstract class have normal methods?

1108

What is the full form of oops?

1247

What is the importance of oop?

1146

What is encapsulation and abstraction? How are they implemented in C++?

1188

Can we have inheritance without polymorphism?

1079

Prepare me a program for the animation of train

2539

What is difference between oop and pop?

1238

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...

2175

Write a program to reverse a string using recursive function?

2415