the answer is b becouse the query the query compares one row at a time an

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

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

Answer Posted / dilip

the answer is b becouse the query the query compares one
row at a time and there is multiple rows generated in
subqueries

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is abstraction in oop?

1138

What is polymorphism explain its types?

1167

What is inheritance and how many types of inheritance?

1105

Advantage and disadvantage of routing in telecom sector

1308

What are the 4 pillars of oop?

1151

How do you achieve runtime polymorphism?

1049

Can you explain polymorphism?

1113

• What are the desirable attributes for memory managment?

2233

What is multilevel inheritance in oop?

1043

what is graphics

2464

What is inheritance in oop?

1036

Can destructor be overloaded?

1035

What is destructor example?

1049

write a program to find 2^n+1 ?

2072

What is protected in oop?

1079