Est. Budget: $10.00
I have a database table named "married" that consist of numerous fields, two fields in particular make-up the table primary-key. Those two field names are; "number", "date".
There are many records in duplicate that share the same "number" but have different "dates" associated.
I need to delete the record (row) within each pair, where the "number" is common between the two, but has the older "date" associated.
Please reply with the query that will accomplish this and I will assign ...