+3 votes
in Sql by

How can you delete duplicate records in a table with no primary key?

1 Answer

0 votes
by

Use the SET ROWCOUNT command.  So if you had 2 duplicate rows you would issue SET ROWCOUNT 1, then your DELETE command then SET ROWCOUNT 0.

...