Duplicates appart from 1 field.

[Kold]

Hi.

I have a table containing 4 columns. There are a number of duplicates that have the same data in 3 columns, the 4th column is time, which is always different.

The following 'nearly' works. The time field is obviously not included.
SELECT DISTINCT ID, State,OptUser FROM tblStatus ORDER BY ID DESC

If I add the time, all fields are returned as they are all different.

I need to remove the duplicates. It doesnt matter which date gets removed, preferably the latest one stays, but doesnt matter.

Thanks for any info!!

[Lars_Berg]

SELECT ID,State,OptUser, max(dateColumn)
   FROM tblStatus 
group by ID,State,OptUser
 ORDER BY ID DESC