Duplicate records

[bamundsen]

I have a table that contains duplicate records. I need to identify the duplicates and remove them. Table example:

UniqueID YearID VehicleID
====== ====== =========
001 41 1
002 39 2
003 40 3
004 41 1
005 41 5

Is there any way I can query for all duplicate VehicleID's having a YearID value of 41?

Thanks,

Brett

 

[hmckillop]

Have a look at

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

"I'm living so far beyond my income that we may almost be said to be living apart

 

[Glasgow]

And thread183-880870 might help.