SQL 语句 查询重复&删除重复数据

– 查询重复数据

	* 
FROM
	( SELECT ROW_NUMBER ( ) OVER ( PARTITION BY "Title" ORDER BY "CreationTime" ) AS RowNumber,* FROM "Ets.Question" ) T 
WHERE
	T.RowNumber > 1

– 删除重复数据
Delete T From

(Select Row_Number() Over(Partition By name,paper_id,[index] order By [author_id]) As RowNumber,* From t_dblp_author)T
Where T.RowNumber > 1