Hello
I need to filter the fields dt_liberacao by the biggest date and the value (peso_pre, peso_pos e peso_pos_ult)
if the value of the largest date is null, you need to get the second largest.
exempl:
it is necessary that only the values peso_pre 78.15, peso_pos 76.45 and peso_pos_ult 76.9 remain on the line
CREATE TABLE ktv_hd (
DT_LIBERACAO DATE ,
PESO_PRE VARCHAR2(30) ,
PESO_POS VARCHAR2(20) ,
PESO_POS_ULT VARCHAR2(20)
)
/
INSERT INTO ktv_hd VALUES (TO_DATE('03/02/2021 20:51:46','DD/MM/YYYY HH24:MI:SS'),NULL,'76,45','76,9');
INSERT INTO ktv_hd VALUES (TO_DATE('03/02/2021 19:37:19','DD/MM/YYYY HH24:MI:SS'),NULL,'76,9',NULL);
INSERT INTO ktv_hd VALUES (TO_DATE('03/02/2021 16:30:50','DD/MM/YYYY HH24:MI:SS'),'78,15','76,9',NULL);
INSERT INTO ktv_hd VALUES (TO_DATE('01/02/2021 21:25:50','DD/MM/YYYY HH24:MI:SS'),NULL,'76,9','77');
INSERT INTO ktv_hd VALUES (TO_DATE('01/02/2021 17:21:58','DD/MM/YYYY HH24:MI:SS'),'79',NULL,NULL);