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
- 14709 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / rupali
Option 2 is correct.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the components of marker interface?
Write a java applet that computes and displays the squares of values between 25 and 1 inclusive and displays them in a TextArea box
class CTest { public: void someMethod() { int nCount = 0; cout << "This is some method --> " << nCount; } }; int main() { CTest *pctest; pctest->someMethod(); return 0; } It will executes the someMethod() and displays the value too. how is it possible with our creating memory for the class . i think iam not creating object for the class. Thanks in Advance... Prakash
Get me a number puzzle game-program
What is polymorphism and why is it important?
Write a program to implement OOPS concepts such as inheritance, polymorphism, friend function, operator overloading?
Why we use classes in oop?
Can abstract class have normal methods?
design a c++ class for the chess board,provide a c++ class definition for such class(only class definition is required)
What is abstraction in oop?
• What are the desirable attributes for memory managment?
Why is polymorphism needed?
What is and I oop mean?
Who invented oop?
What are the benefits of polymorphism?
