Final Answer is 'Option 2' . Read option 2 and 3 carefully, u

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

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

Answer Posted / girish

Final Answer is 'Option 2' . Read option 2 and 3
carefully, u will get to know why 2 is correct.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the concepts involved in Object Oriented programming.

1178

What is difference between inheritance and polymorphism?

992

Explain the advantages of inheritance.

1104

When not to use object oriented programming?

1047

Is html an oop?

1023

Can we create object of abstract class?

1050

what is different between oops and c++

2483

What are oops functions?

983

What is polymorphism programming?

1094

Give an example where we have to specifically use C programming language and C++ programming language cannot be used?

1590

What does sksksk mean in text slang?

2071

Templates mean

2043

What is polymorphism and its types?

1029

What is object and example?

1140

write knight tour problem which is present in datastructure

2622