Duplicate SQL records

[TheWebDataGuy]

I have a table with some duplicate records and I would like to convert it into a table with unique records.

The table stores employee history in the company. There is one record for each position that an employee held in the company. The records aren't technically duplicate. The office address or title may be different. I would like to keep the first record for each employee and delete the rest.
Unfortunately, the data that I got from the DW doesn't have a time stamp which I could have used to keep the latest records only. Here are some of the important columns:

EmployeeID; FirstName; LastName; Title; EmpDate; Address

Any ideas??

Thanks,

 

[r937]

without a time stamp, how do you propose to identify the "first" row for each employee?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[jdgonzalez]

You could try something like this:

http://www.15seconds.com/issue/011009.htm

It'll only delete records that appear more than once.