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
- 14696 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / sharmaamitanand
In my knowlenge if i run this query,the subquery is likely
to return more than single rows as resultset as OR condition
is used so 3rd option is likely to be occured.
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
what's the basic's in dot net
What is methods in oop?
can inline function declare in private part of class?
What is for loop and its syntax?
What is object-oriented programming? Webopedia definition
Question: Write a program that prints a paycheck. Ask the program user for the name of the employee, the hourly rate, and the number of hours worked. If the number of hours exceeds 40, the employee is paid “time and a half”, that is, 150 percent of the hourly rate on the hours exceeding 40. Be sure to use stepwi se refine ment and break your solution into several functions. Use the int_name function to print the dollar amount of the check.
What are two types of polymorphism?
What is purpose of inheritance?
What is polymorphism and why is it important?
What causes polymorphism?
Give two or more real cenario of virtual function and vertual object
What is Difeerence between List obj=new ArrayList(); and ArrayList obj=new ArrayList()?
What is difference between multiple inheritance and multilevel inheritance?
what is different between oops and c++
What is destructor oops?
