Find duplicate row and differentiate with date

declare @tbl table

(ratedate date,currency varchar(3), minlos int,maxlos int,cutoff int)

insert into @tbl

select '2018-06-01','INR',12,15,0

union all

select '2018-06-02','INR',12,15,0

union all

select '2018-06-03','INR',3,13,2

union all

select '2018-06-04','INR',5,12,4

union all

select '2018-06-05','INR',5,12,4

union all

select '2018-06-06','INR',8,1,5

;with cte as (

select ROW_NUMBER() over (partition by MinLos,MaxLOS,CutOff order by RateDate asc) as rwno,RateDate,MinLos,MaxLOS,CutOff from

@tbl )

select * into #temp from cte

order by RateDate

select cast(a.ratedate as varchar)+'-'+cast(isnull(tbl.ratedate,a.ratedate) as varchar) as ratedate,

a.minlos,a.maxlos,a.cutoff from #temp a left join (select * from #temp b where b.rwno=2 ) tbl on a.minlos=tbl.minlos and a.maxlos=tbl.maxlos and a.cutoff=tbl.cutoff

where a.rwno=1