@vegetableChick
```
-- part 为 month 对应用谁分组
-- 注意 order by 的顺序
select z.month,z.count,z.rank
from
(select
x.*,
@rownum := @rownum + 1,
if(@part = x.month,@r := @r + 1,@r := 1) as rank,
@part := x.month
from
(
select
*
from
test e
order by
e.month asc,e.count desc) x,
(
select
@rownum := 0,
@part := null,
@r := 0) rt)z
where z.rank in (1,2)
```