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
- 10782 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / jz
select deptno,max(sal) from emp
group by deptno
having max(sal)>(select avg(sum(sal) )from emp
group by deptno)
:)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Is it possible to use a client with different version than that of its Informatica server?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is informatica worklet?
In informatica workflow manager, how many repositories can be created?
What is a passive transformation?
What are the static cache and dynamic cache in informatica?
Reusable transformation and shortcut differences
How to extract sap data using informatica? What is abap? What are idocs?
Why sorter is an active transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How might one distinguish in the case of mapping is right or not without associating session?
What do you mean by channel change?
What is the benefit of session partitioning?
Which transformation should we use to normalise the COBOL and relational sources?
What is Index Caches size?
