select month from( select month,dense_rank()over(order by count(1) desc)dk from tt group by month) where dk=1
多谢,,,能解释一下rank over 怎么用吗?
dense_rank是一个分析函数 你查下分析函数的用法 这里不容易讲清楚
/* Formatted on 2009/10/16 14:30 (Formatter Plus v4.8.6) */ SELECT b.MONTH AS 月份, b.counts AS 出现次数 FROM ( /*按月份统计出现个数*/ SELECT MONTH, COUNT (MONTH) AS counts FROM emp a GROUP BY a.MONTH) b /*取出现次数最多的月份*/ WHERE b.counts IN (SELECT MAX (c.counts) FROM (SELECT MONTH, COUNT (MONTH) AS counts FROM t a GROUP BY a.MONTH) c)
select month,dense_rank()over(order by count(1) desc)dk
from tt group by month)
where dk=1
你查下分析函数的用法
这里不容易讲清楚
SELECT b.MONTH AS 月份, b.counts AS 出现次数
FROM (
/*按月份统计出现个数*/
SELECT MONTH, COUNT (MONTH) AS counts
FROM emp a
GROUP BY a.MONTH) b
/*取出现次数最多的月份*/
WHERE b.counts IN (SELECT MAX (c.counts)
FROM (SELECT MONTH, COUNT (MONTH) AS counts
FROM t a
GROUP BY a.MONTH) c)