有重的记录
[mysql]
select `pub_number`
from `target_sheet`
group by `pub_number`
having count(`pub_number`)>1
[/mysql]
各自重复的次数
[mysql]
select `pub_number`,count(*) as “total” from `target_sheet`
group by `pub_number` having count(`pub_number`)>1
[/mysql]