侧边栏壁纸
博主头像
小医仙博主等级

风一程雨一程,身向榆关那畔行。

  • 累计撰写 39 篇文章
  • 累计创建 16 个标签
  • 累计收到 0 条评论

目 录CONTENT

文章目录

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

小医仙
2022-05-31 / 0 评论 / 0 点赞 / 568 阅读 / 71 字

– 查询重复数据

	* 
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

评论区