查找Sql Server表重复项 [英] Finding Sql server table Duplicates

问题描述

大家好，


我有一张桌子....在这张桌子上，我的桌子上有重复的ID数量.....
它具有相同的ID，但其他列的数据不同....
问题是我正在为其他具有相同ID的列获取相同的数据...
例如，日期具有相同的ID ........
我想找到其他ID一样的ID和数据相同的ID的数量.


请帮帮我......
如果有人知道这件事
谢谢你

Hi all,


I have one table....in tht table i have number of duplicate ids in table.....
It has same id but different data for other columns.......
the problem is i am getting same data for other columns with same id...
for example date has same for ids of same........
I want to find how many ids are there like tht with same id and same data for other colums also


Please help me......
if anyone knows regarding this
Thank You

推荐答案

以下链接将对您有很大帮助.检查一下
http://blog.sqlauthority.com/2007/07/11 /sql-server-count-duplicate-records-rows/ [

Hi,

Following link will help u a lot. check it out
http://blog.sqlauthority.com/2007/07/11/sql-server-count-duplicate-records-rows/[^]

Best Luck
happy Coding:)

您可以进行此操作.重复的问题

这篇关于查找Sql Server表重复项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！