واکشی اطلاعات از یک جدول با شرط MAx

[رامین مرادی]

سلام اینو تست کنید ببینید جواب میده
خیلی ضایع نوشتم فقط

;with cte1 as( select Date , Vadeh,BakhshId from TblRejimDayes where BakhshId=12)

,cte2 as(select *,ROW_NUMBER() OVER (PARTITION BY BakhshId ORDER BY Date Desc ) AS rn from  cte1)

,cte3 as (select * from cte2 where cte2.rn=1)

,cte4 as (select *,ROW_NUMBER() OVER (PARTITION BY BakhshId ORDER BY Vadeh Desc ) AS rn from  cte3)

select * from  cte4 where cte4.rn=1