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 / 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
Is this job good for future? can do this job post grduate student?
What are the 3 principles of oop?
What is inheritance write a program to show use of inheritance?
What is polymorphism and types?
What is abstraction in oops with example?
what type of question are asked in thoughtworks pair programming round ?
Which is not an object oriented programming language?
What are the types of abstraction?
Advantage and disadvantage of routing in telecom sector
Which type does string inherit from?
What is the difference between static polymorphism and dynamic polymorphism?
How to hide the base class functionality in Inheritance?
How do you answer polymorphism?
write a C++ program for booking using constructor and destructor.
Can an interface inherit a class?