有史以来最简单的语句

[mfc2003]

现 有一表 GCCS
id name finish
0001 工程1 0
0002 工程2 0
0003 工程3 0
0004 工程1 1

我想得到 表中 字段 name 值 相同的数据~~~~

[leeboyan]

select * from gccs where name in
(select name from gccs group by name having count(1)>1)

[lencon]

select * from gccs group by name

[lencon]

select * from gccs group by name

[tdtjjiao]

create table GCCS (id varchar(4), name varchar(10), finish int)
insert GCCS (id, name, finish) values('0001', '工程1', 0)
insert GCCS (id, name, finish) values('0002', '工程2', 0)
insert GCCS (id, name, finish) values('0003', '工程3', 0)
insert GCCS (id, name, finish) values('0004', '工程1', 1)

select * from gccs where name in
(select name from gccs group by name having count(1)>1)

drop table GCCS

[paoluo]

这个应该效率高点


create table GCCS (id varchar(4), name Nvarchar(10), finish int)
insert GCCS (id, name, finish) values('0001', N'工程1', 0)
insert GCCS (id, name, finish) values('0002', N'工程2', 0)
insert GCCS (id, name, finish) values('0003', N'工程3', 0)
insert GCCS (id, name, finish) values('0004', N'工程1', 1)
GO
Select * from GCCS A Where Exists(Select * from GCCS Where name=A.name Having Count(*)>1)
Drop table GCCS
GO

[mind_1220]

create table GCCS (id varchar(4), name Nvarchar(10), finish int)
insert GCCS (id, name, finish) values('0001', N'工程1', 0)
insert GCCS (id, name, finish) values('0002', N'工程2', 0)
insert GCCS (id, name, finish) values('0003', N'工程3', 0)
insert GCCS (id, name, finish) values('0004', N'工程1', 1)
GO
SELECT name
FROM GCCS a
WHERE EXISTS
(SELECT *
FROM GCCS b
WHERE a.name = b.name
HAVING COUNT(*) > 1)
GROUP BY name
GO

[北极海hein]

Select * from GCCS A Where Exists(Select * from GCCS Where name=A.name Having Count(*)>1)