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
How do you define social class?
What polymorphism means?
What is abstraction example?
What is data binding in oops?
write a code for this. serial_number contained in the header of the file will be read , if this serial number is less than a previous serial number within a successfully processed file, or is the same as another serial number within a successfully processed file, or if the field contains anything other than 7 digits, then the file must error with the reason ‘Invalid SERIAL_NUMBER’.
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 it so that we can have virtual constructors but we cannot have virtual destructors?
Why do we need polymorphism in c#?
program for insertion ,deletion,sorting in double link list
Is enum a class?
Can we define a class within the interface?
Is react oop?
What is oops in simple words?
How is polymorphism achieved?
What is the difference between abstraction and polymorphism?