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 / 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
What is multilevel inheritance explain with example?
write a program to find 2 power of a 5digit number with out using big int and exponent ?
What is overloading in oops?
Why do we use oops?
What do you mean by variable?
Can abstract class have normal methods?
What is class and example?
Can enum be null?
Explain virtual inheritance?
design a c++ class for the chess board,provide a c++ class definition for such class(only class definition is required)
INSTANCE FIELDS DECLARED private ARE ACCESSIBLE BY THE METHODS ONLY.CAN WE CHANGE THE private FIELD OF AN OBJECT IN A METHOD OF SOME OTHER OBJECT OF THE SAME CLASS?
How is class defined?
Whats oop mean?
What is balance factor?
What is polymorphism give a real life example?