上面那个放进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;
点赞 评论

相关推荐

代码飞升_不回私信人...:别这样贬低自己,降低预期,放平心态,跟昨天的自己比。做好自己,反而会效率更高心态更好,加油兄弟
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务