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
- 11230 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / moorthy g
select deptno, max(sal) from emp group by deptno
having max(sal)> (select avg(max(sal)) from emp group by
deptno);
Output:
DEPTNO MAX(SAL)
---------- ----------
10 5000
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
What are data-driven sessions?
What is difference between a gateway node and worker node?
What is meant by lookup transformation?
What are different types of transformations available in informatica?
Explain about cumulative Sum or moving sum?
What are the different options available for update strategy?
What is the cumulative sum and moving sum?
Make a note of the quantity vaults made in informatica?
What are the data movement modes in informatica?
What is aggregate cache in aggregator transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is a grid in Informatica?
What is decode in informatica?
Differences between version 7.x and 8.x.
