1.建表
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table1](
[id] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[name] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[table1](
[id] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[name] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
2.插入数据
3.sql:
select * from table1 a
where
name=
(select name from table1 b
group by name
having count(name)>1
)
where
name=
(select name from table1 b
group by name
having count(name)>1
)