如何查询某个字段相同值的记录

[ljh123666]

有一个表table，有user、phonenumber字段，现想查询phonenumber出现1次以上的phonenumber，应如何做呢？谢谢。

[crazyflower]

select phonenumber from table group by phonenumber having count(phonenumber)>1

[wangdehao]

select phonenumber from tb
group by phonenumber
having count(*)>1

[hellowork]

SELECT * from table as a where exists(select 1 from table where phonenumber = a.phonenumber group by phonenumber having count(*) > 1)

[冷箫轻笛]

select phonenumber from table
group by phonenumber
having count(1) > 1

[caixia615]

select *form table group by phonenumber having count(*)>1