Hello Marc-Olivier, that SELECT will not work because of
a) the ORDER BY is applied *after* the ROWNUM < 2 predicate b) depending on the isolation level, auto commit flag etc., you may find values inserted by some other session. You might instead do a SELECT table_name.CURRVAL from DUAL to get the last assigned value of the serial column in the table_name table in the current database session. Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Marc-Olivier Meunier [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 10, 2003 11:47 AM > To: 'Sapdb. General' > Subject: How to get the id of the last inserted row ? > > > Hi all > > I'm looking for a way to get the id of the last inserted row > in a table > In fact, i would like to know if there is something with sessions when > inserting a row. > For example : i insert a row in a table which contains a SERIAL(1) > default value for the id. > If the next instruction is SELECT * FROM mytable WHERE rowno < 2 ORDER > BY id DESC > Will i get my last inserted row or not ? Considering that my db is > linked to a web server with dozens query at the same time. > > Is there any other trick if this doesn't work ? > Is a dbproc executed in a row or is it possible that two dbproc are > executed at the same time ? > > Thanx > > -- > Marc-Olivier Meunier > Ing�nieur Projet BKLINK > MVH-IRIS > 14, rue Rougemont > 75009 Paris > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
