SQL求教

[二当家]

一张表A 有个列名是name
还有个列名是id
找出id重复的数据

[zoujp_xyz]

select ...
from tb group by id having Count(*)>1

[dawugui]

[Quote=引用楼主 keinshen 的帖子:]
一张表A 有个列名是name
还有个列名是id
找出id重复的数据
[/Quote]
select * from tb where id in (select id from tb group by id having count(id) > 1)

[等不到来世]

select * from tb a
where (select count(id) from tb where id=a.id)>1

[anovice]

select * from a where id in 
(select id from a group by id having count(*)>1)

[xabcxyz]

楼上快速啊，再来一个笨办法的:

select * from tb
where id in (
select id from (
select id, count(*) as cnt from tb group by id
) where cnt>1
)
order by id

[zjw2004112]

select * from a where id in
(select id from a group by id having count(*)>1)

[nalnait]

mark...