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
- 14693 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
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
How do you achieve runtime polymorphism?
Write a C++ program without using any loop (if, for, while etc) to print prime numbers from 1 to 100 and 100 to 1 (Do not use 200 print statements!!!)
What is difference between abstraction and encapsulation?
What is encapsulation example?
What does and I oop mean?
What is multilevel inheritance explain with example?
What is methods in oop?
Can enum be null?
Why do we need polymorphism in c#?
What is the difference between a constructor and a destructor?
What is property in oops?
What is encapsulation in oop?
write a program that takes input in digits and display the result in words from 1 to 1000
officer say me - i am offered to a smoking , then what can you say
What is inheritance in simple words?
