In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / sanju
select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
What is primary and backup node?
What is a connected transformation?
Is it possible to revert a global repository to local one and why?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to open an older version of an object in the workspace?
If informatica has its scheduler why using third party scheduler?
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
Implementation methodology
waht type of interface is used for testing the data in informatica
Differentiate between a database and data warehouse?
What is powercenter on grid?
What is difference between a gateway node and worker node?
How are the sources and targets definitions imported in informatica designer?
Explain the features of connected and unconnected lookup.