备注数据表中的重复记录 [英] Remarks against duplicate record in data table

问题描述

我有一个数据表，它包含一些Duplicate行。在数据表的Is_duplicate列中我想添加标志Y.







建议我最好的方式。



我们还可以过滤Some列的组合。

I have a data table it contains some Duplicate row . in Is_duplicate column of datatable i wants to add flag Y.



Suggest me best way.

Can we also filter on combination of Some column.

推荐答案

转到这里编辑数据集中的数据 [ ^ ]

或者您使用：

ROW_NUMBER（）函数

Or you use:
ROW_NUMBER() function

SELECT *, ROW_NUMBER() OVER (PARTITION BY col1, col2, col3, col4 ORDER BY (SELECT 0)) AS DuplicateRowNumber
FROM table
where DuplicateRowNumber > 1

或您创建一个CTE对象：

or you create a CTE object:

WITH cte AS
(SELECT *, ROW_NUMBER() OVER (PARTITION BY col1, col2, col3, col4 ORDER BY (SELECT 0)) AS DuplicateRowNumber
    FROM table
)
UPDATE cte WHERE DuplicateRowNumber > 1

这篇关于备注数据表中的重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！