上面那个放进SQL有点问题,下面这一段可以跑出来:
select p1.月份,p1.seller_name from
( select '2019M5' as 月份, seller_name,sum(gmv) as sum
from purchase
where month(dt)=5
group by seller_name
order by sum
limit 50) p1
union
select p2.月份,p2.eller_name from
( select '2019M6' as 月份, seller_name,sum(gmv) as sum
from purchase
where month(dt)=6
group by seller_name
order by sum
limit 50) p2;