Thursday, February 10, 2011

Get the value of the last row inserted


SELECT P_SR_NO FROM DYN_TRIG_EMPLOYEE_ASSIGNMENT WHERE MODIFY_DATE = ( SELECT MAX(MODIFY_DATE) FROM DYN_TRIG_EMPLOYEE_ASSIGNMENT)

No comments:

Post a Comment