My table have 2 variables; Var1 and Var2.
Every value for Var1 is unique. Var2 can be any real number.
I want to delete every record but the last one.
Since the Var1 values are unique both last.Var1 and first.Var1 always have the value 1, so I have no use for them.
The number of records can vary for each day.
How can I succeed with the deletion?
Susan