oracle中统计邮箱的总类

select count(id) as idcount,substr(person_email,(instr(person_email,'@',1,1)+1)) from tb_person group by substr(person_email,(instr(person_email,'@',1,1)+1)) order by idcount desc

统计邮箱的总类，person_email是邮箱字段。