with       
  table_1 as        
    (       
        select 111 as id, to_date('11/05/2020', 'dd/mm/yyyy') as dt, 13 as val from dual union all       
        select 222 as id, to_date('05/05/2020', 'dd/mm/yyyy') as dt, 10 as val from dual union all  
        select 333 as id, to_date('29/04/2020', 'dd/mm/yyyy') as dt, 19 as val from dual union all  
        select 222 as id, to_date('29/04/2020', 'dd/mm/yyyy') as dt, 18 as val from dual union all  
        select 333 as id, to_date('23/04/2020', 'dd/mm/yyyy') as dt, 17 as val from dual union all  
        select 111 as id, to_date('15/04/2020', 'dd/mm/yyyy') as dt, 18 as val from dual union all  
        select 222 as id, to_date('13/04/2020', 'dd/mm/yyyy') as dt, 11 as val from dual union all  
        select 111 as id, to_date('30/03/2020', 'dd/mm/yyyy') as dt, 14 as val from dual union all  
        select 444 as id, to_date('06/05/1987', 'dd/mm/yyyy') as dt, 12 as val from dual   
    )       

select id, dt, val from table_1   
where (id, dt) in (select id, max(dt) from table_1 where id in (select * from oldDtTab) group by id) 

select id, dt, val from table_1 
where (id, dt) in (select distinct id, max(dt) over(partition by id) mDt from table_1)
order by id

select distinct first_value (id) over(partition by id order by dt DESC) id, 
                first_value (dt) over(partition by id order by dt DESC) mDt,
                first_value (val) over(partition by id order by dt DESC) val
from table_1 
order by id

select distinct id, 
                first_value (dt) over(partition by id order by dt DESC) mDt,
                first_value (val) over(partition by id order by dt DESC) val
from table_1 
order by id

select id, max(dt) dt, max(val) keep (dense_rank first order by id, dt desc) val 
from table_1 group by id;

Select id, dt, val from (
                        select id, dt, val, row_number()  over(partition by id order by dt desc) rNum from table_1
                         ) t
where t.rNum = 1
order by id

,ppdFact AS
(
	SELECT well_id wid,value val FROM WELLOP_INT.V_WELL_MEASURE_OR WHERE measure_type_id=7086 AND measure_date>sysdate-90 
		AND (well_id,measure_date) IN
						(
						SELECT well_id, max (measure_date) FROM WELLOP_INT.V_WELL_MEASURE_OR 
						WHERE measure_type_id=7086 AND well_id IN (SELECT DISTINCT ppdId FROM kTab) AND measure_date>sysdate-90 
						GROUP BY well_id
						)
)
SELECT * FROM ppdFact

,ppdFact AS
(
	SELECT well_id wid, max(value) keep (dense_rank first ORDER BY well_id, measure_date desc) val
	FROM WELLOP_INT.V_WELL_MEASURE_OR 
	WHERE measure_type_id=7086 AND measure_date>sysdate-90 AND well_id IN (SELECT DISTINCT ppdId FROM kTab)
	GROUP BY well_id
)
SELECT * FROM ppdFact