在SQL中删除重复记录的简单方法?(Simple way to remove duplicate records in SQL?)

351 IT屋

how can i remove all duplicate records from 4 columns in 4 different tables and keep one of them as original one.(doesn''t matter which one)
also my tables are quite large so i would rather not inner join them.


What I have tried:

i have tried inner joining the tables but it takes a lot of time.

解决方案
Haver you looked at the SQL SELECT DISTINCT Statement[^]

如何从4个不同的表中的4列中删除所有重复记录,并保留其中一个作为原始记录。(无关紧要)

我的表也是相当大,所以我宁愿没有内心加入他们。





我尝试了什么:



i已尝试内部加入表格,但需要花费很多时间。

解决方案
哈弗你看了 SQL SELECT DISTINCT声明 [ ^ ]

本文地址:IT屋 » 在SQL中删除重复记录的简单方法?