Hello to all
Please, I need help to this my problem
This is my table
CFISCALE VARCHAR2(16) NOT NULL,
DATARE DATE NOT NULL,
FCONSENSO VARCHAR2(1) NOT NULL,
K_MED VARCHAR2(4) NOT NULL,
D_MED VARCHAR2(50) NOT NULL,
EVENTO_ORIGINE VARCHAR2(1) DEFAULT 'R' NOT NULL,
USER_ID VARCHAR2(50) DEFAULT user,
DATA_ORA_RG DATE DEFAULT sysdate)
IN this situation
INSERT INTO PAZIENTI_DOSSIER_SAN VALUES ('STBXXX75D15D110O', '16/01/2019' , 'S', '204', 'XXXXXXXXX', 'R', 'x1', sysdate);
INSERT INTO PAZIENTI_DOSSIER_SAN VALUES ('STBXXX75D15D110O', '16/01/2019' , 'S', '204', 'XXXXXXXXX', 'R', 'x1', sysdate);
INSERT INTO PAZIENTI_DOSSIER_SAN VALUES ('STBXXX75D15D110O', '16/01/2019' , 'S', '204', 'XXXXXXXXX', 'R', 'x1', sysdate);
INSERT INTO PAZIENTI_DOSSIER_SAN VALUES ('STBXXX75D15D110O', '16/01/2019' , 'S', '204', 'XXXXXXXXX', 'R', 'x1', sysdate);
Inserting 4 rows, they can have same datetime
DATA_ORA_RG
S 16/01/2019 02/11/2019 11:05:32
S 16/01/2019 02/11/2019 11:05:32
S 16/01/2019 02/11/2019 11:05:32
S 16/01/2019 02/11/2019 11:05:32---- I have to get this one
how can I get last row inserted(in my sample it is the fourth)
SELECT FCONSENSO --into FCONSENSOX
from (SELECT
A.FCONSENSO, A.DATARE, max(A.DATA_ORA_RG ) over (partition by cfiscale) as max_date
FROM PAZIENTI_DOSSIER_SAN A
WHERE A.CFISCALE = 'STBXXX75D15D110O'
AND A.DATARE is not null
)
where DATARE = max_date;
Instead I get it returns all 4 rows
Thanks for help and time to anyone