就像是:
DELETE FROM the_table_with_no_name
WHERE date_column != (SELECT MAX(t2.date_column)
FROM the_table_with_no_name t2
WHERE t2.id = the_table_with_no_name.id);
根据最大日期/时间删除Oracle中的重复记录
就像是:
DELETE FROM the_table_with_no_name
WHERE date_column != (SELECT MAX(t2.date_column)
FROM the_table_with_no_name t2
WHERE t2.id = the_table_with_no_name.id);