mysql查询id是否重复

select id,count(*) as count from measanalog group by id having count>1;

 

posted @ 2019-07-10 11:13  MagicAsa  阅读(697)  评论(0编辑  收藏  举报