小弟菜鸟，问个简单的问题。

[humin1906]

怎么样能够查询出一个表中所有电话号码一样的记录。并把这些相同的号码提取出来。
谢谢了！！！

[lsxaa]

select * from t a where (select count(*) from t where phone=a.phone)>1

[vinsonshen]

select phone from 表 group by phone having count(*)>1

[lzymagi]

select phone from table where phone in (select phone,count(*) from table group by phone having count(*)>1)
或
select phone ,count(*) from table grou by phone having count(*)>1