如何在同一个表中查找并保存重复值？ [英] how to find and save the duplicate values in same table?

问题描述

如何在同一个表中查找并保存重复值？

how to find and save the duplicate values in same table?

推荐答案

看看例子：

Have a look at example:

DECLARE @tbl TABLE (ID INT IDENTITY(1,1), SomeData VARCHAR(30))

INSERT INTO @tbl (SomeData)
VALUES('a'),('b'),('c'),
    ('a'),('d'),('e'),
    ('d'),('b'),('f'),
    ('h'),('g'),('c')

--display all
SELECT ID, SomeData
FROM @tbl

--display duplicates
SELECT SomeData, COUNT(SomeData) AS CountOfSomeData
FROM @tbl
GROUP BY SomeData
HAVING COUNT(SomeData)>=1

如需了解更多信息，请参阅：

使用DISTINCT消除重复项 [ ^ ]

查找和/或删除重复行 [ ^ ]

使用LINQ查找重复项 [ ^ ]



注意：你应提供有关您的问题的更多详细信息，至少是样本数据和预期输出。

For further information, please see:
Eliminating Duplicates with DISTINCT[^]
Find and/or Delete Duplicate Rows[^]
Find Duplicates using LINQ[^]

Note: you should provide more details about your issue, at least sample data and expected output.

这篇关于如何在同一个表中查找并保存重复值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！