and t.date = (select max(tt.date) from t tt where ...)

with t as (select level id, 
                  trunc(sysdate) + mod(level,3) date_, 
                  trunc(sysdate) - mod(level,5) start_date,  
                  trunc(sysdate) + 1 + mod(level,5) end_date 
          from dual connect by level <= 10
          ---- test data)[
select * from t 
where /*trunc(sysdate) + 3*/ :param between t.start_date and t.end_date
      and (t.date_, t.id) in (select max(tt.date_) keep (dense_rank last order by tt.date_), 
                                     max(tt.id) keep (dense_rank last order by tt.date_) 
                              from t tt 
                              where /*trunc(sysdate) + 3*/ :param between tt.start_date and tt.end_date);