Re: How do I delete all but most recent record?

[Roland Bouman]

maybe:

delete
from log_table all_entries
where date_field < (
select max(date_field)
from log_table last_entry
where all_entries.name = last_entry.name
and all_entries.ip_address = last_entry.ip_address
)