[ID] int, Atrib bit, [Date] date

with s as
(
 select
  ID, Attrib, [Date],
  row_number() over (order by [Date]) as rn
 from
  Таблица
 where
  Attrib = 1
)
select
 ID, Attrib, [Date]
from
 s
where
 rn = 1;

select top 1 with ties ...
from ...
where Attrib = 1
order by date desc

with s as
(select
     ID, Attrib, [Date],
     row_number() over( partition by datediff(day, 0, [Date]) order by [Date] ) as rn
   from Таблица
   where Attrib = 1
)
select ID, Attrib, [Date] from s where rn = 1;

with cte as
(
  select *, ROW_NUMBER() over(order by date, case Atrib when 1 then 0 else 1 end, ID) RN
  from Table
)
select *
from cte
where RN < (select top 1 RN from cte where Atrib != 1 order by rn)