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
- 11021 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / ravikishore
select deptno,sum(sal) from emp group by deptno having
sum(Sal) =(select max(sum(sal)) from emp group by deptno)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are junk dimensions?
Performance tuning( what you did in performance tuning)
What is the difference between router and filter?
Separate from a database, an information bazaar, and an information stockroom?
How to open an older version of an object in the workspace?
How we can create indexes after completing the loan process?
What is exclusive and normal mode for repository services?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is target designer and target load order?
Is it possible to revert a global repository to local one and why?
What are the components of the workflow manager?
What are the advantages of informatica?
