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
option b is correct...
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What does and I oop mean?
What is difference between inheritance and polymorphism?
What are the three parts of a simple empty class?
What is a superclass in oop?
write string class as your own class in java without using any built-in function
What is methods in oop?
Why is oop better than procedural?
What is encapsulation in simple terms?
class type to basic type conversion
What are properties in oop?
Can destructor be overloaded?
What is inheritance and how many types of inheritance?
What is polymorphism in oop example?
There are two base class B1,B2 and there is one class D which is derived from both classes, Explain the flow of calling constructors and destructors when an object of derived class is instantiated.
write a program to find 2 power of a 5digit number with out using big int and exponent ?