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
- 10780 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
What are the various types of transformation?
which one is better performance wise joiner or look up
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a sorter transformation?
Explain what are the different versions of informatica?
what is unit testing?tell me proceedure
Which are the different editions of informatica powercenter that are available?
What are the data movement modes in informatica?
What are the different ways to implement parallel processing in informatica?
What are roles and groups and benefits of using them?
How to generate sequence numbers using expression transformation?
When do you use sql override in a lookup transformation?
What are the prerequisite tasks to achieve the session partition?
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
Explain pushdown optimization and types in informatica
