查询表中重复字段值。

[sanren2000]

请各位高手帮帮忙。
表如下：
ziduan1 ziduan2
1 1
1 2
1 3
2 1
3 2
当记录很多时候，不知道ziduan1 有多少重复
用什么SQL语句能查询出ziduan1 重复的所有记录
ziduan1 ziduan2
1 1
1 2
1 3
用什么SQL语句能查询出ziduan2 重复的所有记录
ziduan1 ziduan2
1 1
2 1
1 2
3 2

[wind_zhang]

1. select count(ziduan1) from table group by ziduan1 having count(zidian1)>1
上面的语句你用1，和2都试一下，可以看到效果的

[凨叔]

select * from [yourtable] where ziduan1 in
(select ziduan1 from [yourtable] group by ziduan1 having count(ziduan1)>1)

[churchatp1]

1。select * from [yourtable] where ziduan1 in
(select ziduan1 from [yourtable] group by ziduan1 having count(ziduan1)>1)
2。select * from [yourtable] where ziduan2 in
(select ziduan2 from [yourtable] group by ziduan1 having count(ziduan2)>1)

[wangdehao]

select * from [yourtable] where ziduan1 in
(select ziduan1 from [yourtable] group by ziduan1 having count(ziduan1)>1)


--having 子句