查询数据库表schedule中cmId字段重复信息的sql如下: select cmId,count(cmId)as total_count from schedule group by cmId having count(cmId) > 1