select * from a where zh in (select max(zh) from a group by name)
select name,max(time) from table group by name
select a.* from a
INNER JOIN
(select name,max(zh) from a group by name) b
ON a.name = b.name AND a.zh = b.zh
参考：
SQL中row_number函数用法
https://blog.csdn.net/baidu_41797613/article/details/120489521
按产品分组，周倒序排序出序号，之后取排序=1的就是每个产品最新的记录
1min目标场景问卷
立即参与
