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 / manish
Option 3 is right
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is inheritance in oop?
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 is difference between oop and pop?
Is oop better than procedural?
What is the benefit of oop?
what are the realtime excercises in C++?
What is abstraction with example?
Who invented oop?
What is interface? When and where is it used?
Can destructor be overloaded?
• What are the desirable attributes for memory managment?
write a program using c++ to implement single contiguous memory mangement techniques.display the content of the main memory after yhe allocation of jobs and percentage of the wastage of the main memory
What is difference between polymorphism and inheritance?
What is an advantage of polymorphism?
What are benefits of oop?