第一题 SELECT a.day, a.itemid, a.num from goods a JOIN (select day, max(num) as num from goods group by day) b on a.day = b.day and a.num = b.num where a.day < 20190112 order by day
点赞 评论

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务