Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17276 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / nitin
option b is correct because we can not compare more than one values with single value using '=' operator.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is debug class?what is trace class? What differences are between them? With examples.
What is polymorphism and why is it important?
explain sub-type and sub class? atleast u have differ it into 4 points?
What is overriding in oop?
when to use 'mutable' keyword and when to use 'const cast' in c++
Get me an image implementation program.
How to hide the base class functionality in Inheritance?
What is difference between pop and oop?
What is abstraction and encapsulation?
What is basic concept of oop?
What does and I oop mean?
What are classes oop?
What are the 4 main oop principles?
given a set based questions and 5 questions based on it next data sufficiciency questions 2 and 2/3 english sentence completion with options very easy and 2 synononmys paragraph with 10 questions 10 minutes replace =,-,*,% with -,%,+,* type questions 5 3 questions lik following itssickhere itssickthere itssickhere istsickhere which is nt alike the others very easy
I have One image (means a group photo ) how to split the faces only from the image?............ please send the answer nagadurgaraju@gmail.com thanks in advace...
