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 / vicky
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.
4)logical aparatous are not allowed in where clause .
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Can a destructor be called directly?
#include
What is new keyword in oops?
Which method cannot be overridden?
What is abstraction encapsulation?
Are polymorphisms mutations?
can inline function declare in private part of class?
What is difference between data abstraction and encapsulation?
write a programe to calculate the simple intrest and compund intrest using by function overlading
Write a java applet that computes and displays the squares of values between 25 and 1 inclusive and displays them in a TextArea box
Why is abstraction used?
Who invented oop?
What is super in oop?
What is this pointer in oop?
What is inheritance and how many types of inheritance?