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
)