Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get last row inserted

Rosario VigilanteNov 2 2019 — edited Dec 4 2019

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
This post has been answered by Rosario Vigilante on Nov 4 2019
Jump to Answer
Comments
Post Details
Added on Nov 2 2019
16 comments
1,772 views