Question

我在申请协会时工作。 NET C#

I want to view all the duplicated records in a Grid view Control.

I normally use “SqlDataSource” control.

请注意,我不想有一两条共同点的行文,我正试图找到除(PK)外一切相同的行文。

我希望大家理解这个问题。感谢您需要任何其他资料请问我。

Answer 1

SELECT column1, column2, column3, column4, COUNT(1)
FROM yourtable
GROUP BY column1, column2, column3, column4
HAVING COUNT(1) > 1

Answer 2

简而言之,最简单的办法是:

select column1, column2, ... /* all columns except ID */
from myTable
group by column1, column2, ... /* all columns except ID */
having count(*) > 1

Answer 3

您可以把记录整理成册,并记录在你的 que中:

select col1, col2, col3, count(1)
from table
group by col1, col2, col3
having count(1) > 1

Answer 4

There are several ways to do this, here is another:

SELECT t1.*
FROM MyTable t1
INNER JOIN MyTable t2
ON t1.field1 = t2.field1 AND t1.field2 = t2.field2 AND t1.field3 = t2.field3 ... etc ...
WHERE t1.PKID <> t2.PKID

Answer 5

select
    col1,
    col2,
    col3
from
(
    select 
        col1, 
        col2,
        col3,
        row_number() over(partition by Col1, Col2, Col3, ColN order by Col3) rownum
    from yourTable
)a
where rownum > 1

使用了ROW_NUMBER(>)功能,根据重复情况(partition by条)排列了你的记录。然后选择所有重复的行文。

如果没有看到你确切的表层结构,这个通用塔就象我可以提供的那样具体。

Answer 6

谢谢大家,这是我所期待的。

select ProductID, Date, Category, COUNT(*)from Table1GROUP BY ProductID, Date, Category HAVING COUNT(*) > 1 -- gets only rows with more than 1 grouping

友情链接