I have data that looks like this:
CREATE OR REPLACE table sampl (ID,FIELD_NAME,FIELD_VALUE,UPDATE_DATE) as
(
select 1,'Name','Elmer Fudd', TO_DATE('2023-01-01','YYYY-MM-DD') FROM DUAL UNION ALL
select 1,'Age','30', TO_DATE('2023-02-01','YYYY-MM-DD') FROM DUAL UNION ALL
select 1,'Age','29', TO_DATE('2023-03-01','YYYY-MM-DD') FROM DUAL UNION ALL
select 2,'Name','Bugs Bunny', TO_DATE('2023-03-01','YYYY-MM-DD') FROM DUAL UNION ALL
select 2,'Name','Bugs Bunny', TO_DATE('2023-04-01','YYYY-MM-DD') FROM DUAL UNION ALL
select 2,'Age','13', TO_DATE('2023-04-01','YYYY-MM-DD') FROM DUAL
)
Actual result:-
ID NAME AGE
1 null 29
2 Bugs Bunny null
Expected:-
ID NAME AGE
1 Elmer Fudd 29
2 Bugs Bunny 13