+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.

Related questions

+2 votes
asked Jan 15, 2022 in Sql by GeorgeBell
+2 votes
asked Jan 14, 2022 in Sql by GeorgeBell
...