HELP, QUERY PROBLEMS

[Toby Yu]

Dear all,

I got a table which contains the following fields:

ResultsID, Site, DateStamp, Result, Annual,AssignmentID, RiskID, Rank

In the existing table, I wanna delete the duplicated data. The duplicated data can be described as only DateStamp and ResultsID field value are different whereas all the other fields are all the same.
Eg:
ResultsID, Site, DateStamp, Result, Annual,AssignmentID, RiskID, Rank
1250 MSM 2007-10-11 OK 128.50 130332 63 2
1251 MSM 2007-10-12 OK 128.50 130332 63 2
1253 ABC 2007-10-11 OK 118.40 130332 63 1

these first two records can be considered as the duplicated ones coz the oly difference between them are ResultID and Datestamp. How I can delete the duplicated records? and just keep one record.

Any reply will be appreciated!



Edited 4 time(s). Last edit at 12/10/2007 09:38AM by Toby Yu.