Duplicate records in SQL delete table only one left

Insert duplicates when inserting data accidentally today

There are no primary key foreign keys in this table, you may insert or delete them arbitrarily.

There's a lot of complicated statements on the web that don't solve the problem.

Finally, use delete top (1) to solve the problem

Delete Top (1from where='xiaomin'

can also be used

Update  Top (1) from the person where name = ' xxxx ' delete from the person where name = ' xxxx '

It's not that complicated.

Duplicate records in SQL delete table only one left