--创建表 并在表中添加重复数据
CREATE TABLE [dbo].[repeat](
[emp_no] [nvarchar](50) NULL,
[name] [nvarchar](50) NULL,
[age] [int] NULL
) ON [PRIMARY]
--插入重复的测试数据如下图
-- 查询重复数据
方法 一
select * from repeat where name in (select name from repeat group by name having count(*)> 1)
方法 二
select * from repeat where (select count(*) from repeat r where r.name=repeat.name) >1