with new_a as ( select * from a where (id,dt) in ( select id ,max(dt) from a group by id) ) select new_a.id, new_a.name, code from new_a full join b on new_a.id = b.id order by new_a.id 这样可以吗?
1 1

相关推荐

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