Answer Posted /
| Is This Answer Correct ? | Yes | No |
Post New Answer View All Answers
What is the WMLScript?
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
How do I change my home page?
Does unicode support all languages?
Risk Analysis a) 2 step, b)3 step, c) 4 step, d) 6 step
What is calculate of tds
What is the difference between lc and bg(letter of credit
What are controlled and uncontrolled components in React?
What is python magic method?
What is difference between SOA and Web Services?
What are report filters and view filters?
What are the types of partitions in oracle?
what is the difference between read the data from table and infotype
Explain fold() operation in spark?
IF DISTANCE IS 100METERS B/W AMP.METER AND CURRENT TRANSFORMER WHAT WILL BE AFFECT IN ACCURACY .METER CAN SHOWING ACCURATE CURRENT OR NOT IF NOT WHAT CAN I DO TO GET 100% ACCURACY.