sql语句-查询某个字段是否有重复数据，重复几次

select count(main_ticker) 
from new_table
group by main_ticker 
having count(main_ticker) > 1;