Delete the duplicate record, but based on the contents of two fields.
Posted on 2013-01-21
When only the contents of one field defines which record is duplicated, I know to create the phrase SQL to delete.
But in this case, not.
Because, I need to delete the duplicate record, but based on the contents of two fields in the table.
When the two fields together, repeat content.
Field1 and Field2
Can anyone help me by writing a sample in SQL?
Please use only standard SQL commands.
Because DB is to use the Firebird, and all DBs perform standards commands.
Thank you very much.