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

问题描述

如何从4个不同表的4列中删除所有重复记录，并将其中之一保留为原始记录.(与哪一个无关)
我的桌子也很大，所以我宁愿不要内部联接它们.


我尝试过的事情:

我已经尝试过内部连接表，但是要花很多时间.

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，您查看了 ^ ]

Haver you looked at the SQL SELECT DISTINCT Statement[^]

这篇关于在SQL中删除重复记录的简单方法?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！