This content has been marked as final. Show 3 replies
Unless you provide some mechanism in your application design to store such a information (a insert date or a sequence or ...) you will not be able to do that. If your status column could indicate the order in which the events for a given person happen, you could use that to get the last row for that person.
I want to know which row is inserted or updated at last time to every person
you cannot select "last rows" with the columns you give us.
You could add a column containing a timestamp and update it with sysdate after every insert/update.