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
Why is there no multiple inheritance?
Why do we use polymorphism?
What is encapsulation in simple terms?
What is abstraction example?
What does oop mean in snapchat?
What is the main purpose of inheritance law?
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.
when to use 'mutable' keyword and when to use 'const cast' in c++
write string class as your own class in java without using any built-in function
Why is object oriented programming so hard?
if i have same function with same number of argument but defined in different files. Now i am adding these two files in a third file and calling this function . which will get called and wht decide the precedence?
Get me an image implementation program.
What are benefits of oop?
What are the components of marker interface?
Can we have inheritance without polymorphism?