I created an external table which records the various states of a place in concert (IE: free, reserved, blocked).
For the same place I can thus have a history with timestamp evolution of this state.
My need is to preserve only the last (timestamp) state.
Who can give me an idea of ideal script to preserve only the last state? (Delete old states)