查询重复次数最多/最少的几条记录
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(T
SELECT DISTINCT count(*) AS count,ip,keywords,pagefrom,pageurl FROM table
WHERE (
pagefrom like "%baidu.com%"
AND keywords !=""
AND pageurl like "%/2011%"
AND pageurl not LIKE "%ozc=2%"
and pa
SELECT keyword, count( * ) AS count
FROM article_keyword
GROUP BY keyword
ORDER BY count DESC
LIMIT 20
此段查询语句返回 article_keyword 表中 keyword 重复次数（count） 最多的20
