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 / rupali
Option 2 is correct.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a null tree?
How many human genes are polymorphic?
What is the renewal class?
What is the point of polymorphism?
What is inheritance write a program to show use of inheritance?
Why do while loop is used?
What is the difference between inheritance and polymorphism?
What is the difference between static polymorphism and dynamic polymorphism?
They started with the brief introduction followed by few basic C++ questions on polumorphism, inheritance and then virtual functions. What is polymorphims? How you will access polymorphic functions in C? How virtual function mechanism works?
Why is polymorphism used?
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
What is difference between oop and pop?
What are constructors in oop?
What are different oops concepts?
What are objects in oop?