Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;
Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400
- 7 Answers
- 10783 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is sorter transformation?
What is mapplet in informatica?
What is the need of an ETL tool?
How do you update the records with or without using update strategy?
What is a repository manager?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What does update strategy mean, and what are the different option of it?
What is a sequence generator transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the components of the workflow manager?
Enlist few areas or real-time situations where informatica is required.
How you can differentiate between connected lookup and unconnected lookup?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain what is informatica metadata and where is it stored?
Describe expression transformation?
