Thanks for this,.. But all these shows the last update . i need Last -1, is there any query ...
to store it permanently with a record then you need to do what fran says with a trigger. Otherwise if youre using the
"select * from table as of timestamp" and youre not seeing the last -1 update, you need to go further back in time and hope your logs will stretch back that far. if they dont, and you really really need to see it, you're either mining logs for the update or you're restoring backups to test instances to get a point in time view of the data.