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
Sorry ...frgot explain why it is 2nd option....everyone
explained it right ..but the answer choosen is incorrect...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
class type to basic type conversion
What is meant by oops concept?
write knight tour problem which is present in datastructure
What is the difference between procedural programming and oops?
What are functions in oop?
What are the advantages of polymorphism?
can inline function declare in private part of class?
Why is oop useful?
What is polymorphism in oop example?
Following are the class specifications: class {int a}; class {int b}; Using friend funtion,calculate the max of two objects and display it.
Can abstract class have normal methods?
What is abstraction in oop with example?
What is abstraction encapsulation?
What is class encapsulation?
can we make game by using c