Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
- 7 Answers
- 12711 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sri
SELECT *FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP WHERE
DEPTNO=10);
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is pmcmd command?
What is rank transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the settings that you use to configure the joiner transformation?
Can we create a Integration service without a Repository service and vice versa?
What is the use of source qualifier?
Explian the Process of deployment groups in informatica
Explain the informatica workflow?
what is the hint? how to use it to reduce the query processing in program?
What is meant by lookup transformation?
What is intricate mapping?
What are the limitations of joiner transformation?
What is the surrogate key?
How can we update a record in the target table without using update strategy?
Implementation methodology
