select id,count(*) as count from measanalog group by id having count>1; 转载于:https://www.cnblogs.com/MagicAsa/p/11162664.html