mysql 数据表中查找重复记录

select mobile_phone,count(*) as count from lawyer group by mobile_phone having count>1;

posted @ 2015-02-04 15:17  潇潇留客  阅读(132)  评论(0)  编辑  收藏  举报