removing duplicate

[Hendrix10]

I have a table that has mutliple records for the same person. I know
how to create a query to remove duplicates but i don't know how to
create a table to remove duplicates but keep the most recent record.
Is this possible?


ie
client status date
123 A 1/1/07
123 C 2/5/06
123 A 9/3/07


results

client status date
123 A 9/3/07

 

[Rod Plastow]

Hi Hendrix (?),

I'm not clear what you want to do.

You have a table with one or more rows for each person and you wish to
delete all but the most recent entry for each person. So far this is clear
but you don't say whether you want to do this in place in the same table or
create a new table. I assume you want to do it in place as this is the more
usual situation. (Think about archiving first?)

Where I get confused is when you mention 'creating a table to remove
duplicates.' Tables are passive entities; they are simply receptacles for
data; in no way are they proactive nor can they operate on data in any way.

Are you by chance asking how you can trigger your query? Or perhaps you
want to keep all rows/records but only display the most recent?

Rod