mysql 查询重复次数最多/最少的几条记录

查询重复次数最多/最少的几条记录
select T.result from(
select  count(*)c,t.result from t_answer t where t.qid =12 group by t.result order by c desc
)as T where T.c = (select min(T1.c) from (select  count(*)c,t.result from t_answer t where t.qid =12 group by t.result order by c desc)T1) 




这样查询有问题
select T2.result from(
select min(c),T1.result from (
select  count(*)c,t.result from t_answer t where t.qid =12 group by t.result 
)T1 )T2