Oracle中 COUNT(count(*))语法 是统计分组后的总数
oracle 例：select count(count(*)) from s_name group by type
mysql 例：select count(*) from (select count(*) from s_name group by type)
a 注意：
Oracle这种语法无法在mysql使用
