i have a table where there is no primary key
i have 5 rows of data
day1 time1
day1 time1
day1 time2
day1 time2
day1 time2
time2 is newer than time1, how should i delete the four oldest record in the table. this means that the only row that will be left on my table is:
day1 time2