Actually the query may return more than one row. Hence "is" shou

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

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

Answer Posted / raghavan

Actually the query may return more than one row.
Hence "is" should be used in place of "=".
So the best answer would be the third choice.

Is This Answer Correct ?

11 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

officer say me - i am offered to a smoking , then what can you say

2066

How to call a non virtual function in the derived class by using base class pointer

6455

Whats is abstraction in oops?

1036

#include #include #include #include void insert(char *items, int count); int main(void) { char s[255]; printf("Enter a string:"); gets(s); insert(s, strlen(s)); printf("The sorted string is: %s.\n", s); getch(); return 0; } void insert(char *items, int count) { register int a, b; char t; for(a=1; a < count; ++a) { t = items[a]; for(b=a-1; (b >= 0) && (t < items[b]); b--) items[b+1] = items[b]; items[b+1] = t; } } design an algorithm for Insertion Sort

2583

Is html an oop?

1023

What is class and object with example?

1083

What does <> mean pseudocode?

1131

Why polymorphism is used in oops?

1020

What is encapsulation in oop?

1011

What is data binding in oops?

1050

Is oop better than procedural?

1007

What is class and example?

1123

Which method cannot be overridden?

1038

hi all..i want to know oops concepts clearly can any1 explain??

2099

Where is pseudocode used?

1057