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 is debug class?what is trace class? What differences are between them? With examples.
What is polymorphism in oop example?
What is object and example?
Why is object oriented programming so hard?
Can an interface inherit a class?
What is the difference between static polymorphism and dynamic polymorphism?
Why do we use polymorphism?
What are oops methods?
What are the 4 main oop principles?
Why we use classes in oop?
What are objects in oop?
What is a null tree?
Write a program to sort the number with different sorts in one program ??
What is encapsulation process?
What is Difference Between Inheritance and creating object and getting data? means Class A extends B{ B.getMethod();} (OR) Class A{ b obj=new B(); obj.getMethod(); }