select *
from (select *,
             row_number() over(partition by URUN_NO order by BASLANGIC_TARIHI desc) as rn
      from BM_T_V_FIYAT_TANIM_BILGI WITH(NOLOCK)) as T
where rn = 1