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
- 8925 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / shankar
select * from emp a where sal>(select avg(sal) from emp b
where a.deptno=b.deptno)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Mention some types of transformation?
What is informatica?
Define Pmrep command?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
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 are connected or unconnected transformations?
What is olap (on-line analytical processing?
What is an Integration service in Informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What can we do to improve the performance of informatica aggregator transformation?
explain abt ur project architecture?
Target increases every day even though no new record was inserted
How can we use batches?
