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
How do you load first and last records into target table?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
What is the way to execute pl/sql script using informatica mapping?
Explain in detail scd type 2 through mapping.
Explain the use of aggregator cache file?
How to load a Dimension ? and how to load a fact table?
Differentiate between reusable transformation and mapplet.
What are the components of Informatica? And what is the purpose of each?
How identifying bottlenecks in various components of informatica and resolving them?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Describe an informatica powercenter?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Define filter transformation?
wf dont have integration severances how you can run?
What is the use of source qualifier?