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
- 14621 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 the use of oops?
How do you define social class?
just right the logic of it 1--> If few people are electing then every time ur candidate should win 2--> arrange books in box, if box carry weight == books weight then take another box..... find the no of box required.
What is object and class in oops?
What is variable example?
What is polymorphism in oops?
What does sksksk mean in text slang?
Why do we use oops?
What is the difference between encapsulation and polymorphism?
What is byval and byref? What are differences between them?
Question: Write a program that prints a paycheck. Ask the program user for the name of the employee, the hourly rate, and the number of hours worked. If the number of hours exceeds 40, the employee is paid “time and a half”, that is, 150 percent of the hourly rate on the hours exceeding 40. Be sure to use stepwi se refine ment and break your solution into several functions. Use the int_name function to print the dollar amount of the check.
What is encapsulation example?
to find out the minimum of two integer number of two different classes using friend function
What is this pointer in oop?
officer say me - i am offered to a smoking , then what can you say
