SQL题：一个表中的ID字段是可以重复的，把该表中有重复ID值的记录查出来，并显示共有多少条记录数。

select count(c.channel_name),c.channel_name from channel c GROUP BY c.channel_name HAVING count(c.channel_name)!=1