For Version 8 (NOW FOR OS/390)

--Select last row only
SELECT *
FROM (SELECT ROW_NUMBER() OVER (ORDER BY empno ASC) AS rownumber,
empno, firstnme
FROM edwarde.employee
) AS foo
WHERE empno = (SELECT MAX(empno) FROM edwarde.employee);





-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x89777567.[Email address protected]
Sent: Thursday, December 23, 2004 12:33 PM
To: LazyDBA Discussion
Subject: DB2 FIND LAST RECORD INSERTED


To All,
The following code can be used to find the last record inserted (not
updated or deleted) into a table (I don't KNOW if this works for a cluster,
partition, etc but it works for a "normal" table).

SELECT DEPTNO, DNAME
FROM DEDBADM.DEPT
ORDER BY DEPTNO DESC
FETCH FIRST 1 ROWS ONLY;




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page