Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17714 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / nitin
option b is correct because we can not compare more than one values with single value using '=' operator.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Why do we use class?
explain sub-type and sub class? atleast u have differ it into 4 points?
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 does and I oop mean in text?
Get me a number puzzle game-program
is there any choice in opting subjects like 4 out of 7
What is abstract class in oops?
What are two types of polymorphism?
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?
What is destructor give example?
What is oops?what is its use in software engineering?
What is abstraction in oops?
what is different between oops and c++
What do you mean by variable?
What is encapsulation with example?
