整理数据的时候经常用到: select count(*),serie_code from serie where from_type='ycw' group by serie_code having count(*) >1;