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
Sorry ...frgot explain why it is 2nd option....everyone
explained it right ..but the answer choosen is incorrect...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Get me a number puzzle game-program
write a program that takes input in digits and display the result in words from 1 to 1000
What is encapsulation in simple terms?
write a C++ program for booking using constructor and destructor.
What is encapsulation c#?
What is polymorphism in oops with example?
What is multilevel inheritance explain with example?
What is and I oop mean?
What is multilevel inheritance?
What is abstraction and encapsulation?
What is encapsulation process?
how to get the oracle certification? send me the answer
How is class defined?
Why is abstraction needed?