select name,city_name from(select name,city_name,row_number ( ) over(partition by name order by last_order_time desc)as row) where row=1 order by name
点赞 评论

相关推荐

牛客网
牛客企业服务