I have a table that has "duplicate" records in it; the variables for the duplicate records are all the same except for a date variable which varies record to record. In the case of a duplicate record I would like to select the record with the latest (newest) date and not select a duplicate record with an earlier date. Each record has an id number that is the same for all
entries in the table. Any suggestions on how to do this would be appreciated.
Linear Mode
