There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
Answer Posted / lokesh y g
select e.no,e.name,e.salary from emp e where salary >
(select avg(salary)as salary from emp e1 where e.no=e1.no
group by no)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is a sequence generator transformation?
How many ways a relational source definition can be updated and what are they?
What is blocking transformation?
How to differentiate between the active and passive transformations?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
draw informatica architecture 8.6 ?
Explain the shared cache and re-cache?
Explain the different kinds of facts.
What is union transformation?
pmscmd startworkflow -sv
What are the differences between a connected lookup and unconnected lookup?
What are the different versions of informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How many ways are there to do 'remove duplicate records in informatica'?
What is the different lookup cache(s)?