I have a postgresql table of tasks with various status of the task like this in table below. where in my last status of the task will be “Deleted”
I want to get the previous status of each task before it is converted as “Deleted” using Postgresql query.