deleting duplicates

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Locked
alchemy9
Posts: 5
Joined: Wed 01 Feb 2006 06:39

deleting duplicates

Post by alchemy9 » Wed 01 Feb 2006 12:29

if you had a table with just 1 column in is there anyway to delete duplicates with out adding a unique column

I was thinking of using msquery.delete

any advice would be greately appreciated.


Ian
Top
Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 06 Feb 2006 10:24

Please see http://crlab.com/forums/viewtopic.php?p=9400#9400
Top
Locked

Return to “SQL Server Data Access Components”