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.
- 10 Answers
- 14719 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
How many human genes are polymorphic?
when to use 'mutable' keyword and when to use 'const cast' in c++
Explain the advantages of inheritance.
What is purpose of inheritance?
Can we create object of abstract class?
What is abstraction in oop?
What is polymorphism and why is it important?
can we make game by using c
write a C++ program for booking using constructor and destructor.
What type of loop is a for loop?
what are the ways in which a constructors can be called?
Can destructor be overloaded?
How to handle exception in c++, For example in a functions i am assigning memory to some variables and also in next instructions in am dividing one variable also. If this functions generates a error while allocating memory to those variable and also while dividing the variable if i divide by zero then catch block how it will identify that this error has cone from perticular instruction
Why do we use class in oops?
What is the advantage of oop over procedural language?
