简单点的

[ZHHAA]

有一个表就一个字段i
i
1
1
7
5
4
7
4
8
如何得出重复的值
如：
i
1
1
4
4
7
7

[子陌红尘]

select t.* from 表 t where t.i in(select i from 表 group by i having count(*)>1)

[水族杰纶]

select i from tb group by i having count(i)>1

[子陌红尘]

declare @t table(i int) 
insert into @t values(1) 
insert into @t values(1) 
insert into @t values(7) 
insert into @t values(5) 
insert into @t values(4) 
insert into @t values(7) 
insert into @t values(4) 
insert into @t values(8)

select t.* from @t t where t.i in(select i from @t group by i having count(*)>1)

/*
i           
----------- 
1
1
7
4
7
4
*/


select t.* from @t t where t.i in(select i from @t group by i having count(*)>1) order by t.i

/*
i           
----------- 
1
1
4
4
7
7
*/

[lgxyz]

SELECT * FROM TB WHERE ID IN (SELECT ID FROM TB GROUP BY TB HAVING COUNT(1)>1)

[lgxyz]

大家速度　真快啊

[水族杰纶]

0