select max(t1.load_dtm), t1.approved_plan,t1.whs_id, t1.month_id
from
(
select max(sp.month_id) as month_id, sp.whs_id, sp.approved_plan,sp.load_dtm from dev_db_out.T_SALES_PLAN SP
where sp.whs_id=530 
group by sp.whs_id,  sp.approved_plan, sp.load_dtm) t1
group by t1.approved_plan,t1.whs_id, t1.month_id

SELECT TOP(1) WITH TIES * FROM dev_db_out.T_SALES_PLAN ORDER BY month_id DESC, load_dtm DESC;

SELECT TOP(1) WITH TIES * FROM dev_db_out.T_SALES_PLAN ORDER BY month_id DESC, load_dtm DESC;

SELECT TOP(1) WITH TIES * FROM dev_db_out.T_SALES_PLAN WHERE whs_id=530 ORDER BY month_id DESC, load_dtm DESC;

select sp3.load_dtm, sp3.whs_id,sp3.month_id, sp4.approved_plan from (

select max(sp2.load_dtm) as load_dtm, sp1.whs_id, sp1.month_id from (
select max(sp1.month_id) as month_id, sp1.whs_id
from dev_db_out.T_SALES_PLAN SP1
 
group by sp1.whs_id ) sp1 inner join dev_db_out.T_SALES_PLAN SP2 
on sp1.whs_id=sp2.whs_id and sp1.month_id=sp2.month_id
group by sp1.whs_id, sp1.month_id	) sp3 inner join dev_db_out.T_SALES_PLAN sp4
on sp3.whs_id=sp4.whs_id and sp3.month_id=sp4.month_id and sp3.load_dtm=sp4.load_dtm

SELECT *
FROM dev_db_out.T_SALES_PLAN
ORDER BY RANK()OVER(PARTITION BY whs_id ORDER BY month_id DESC, load_dtm DESC);

SELECT *
FROM dev_db_out.T_SALES_PLAN
ORDER BY RANK()OVER(PARTITION BY whs_id ORDER BY month_id DESC, load_dtm DESC);

SELECT TOP(1) WITH TIES *
FROM dev_db_out.T_SALES_PLAN
ORDER BY RANK()OVER(PARTITION BY whs_id ORDER BY month_id DESC, load_dtm DESC);

select  whs.whs_id, sp.month_id,sp.load_dtm, sp.approved_plan, lnk.whs_condition_id,lnk.begin_dt,viruchka.opsum 
from PRD_VD_DM.V_WHS WHS
 left join
 dev_db_out.T_SALES_PLAN SP on whs.whs_id=sp.whs_id
 left join PRD_VD_ND.V_WHS_CONDITION_LNK lnk on whs.whs_id=lnk.whs_id
 left join PRD_VD_DM.V_SALES_WHS_AGG_02 VIRUCHKA on whs.whs_id=Viruchka.whs_id and sp.month_id=Viruchka.month_id
ORDER BY RANK()OVER(PARTITION BY sp.whs_id ORDER BY sp.month_id DESC, sp.load_dtm DESC,lnk.begin_dt desc, viruchka.opsum desc, lnk.whs_condition_id desc)