SQL分组后获取其中一个字段最大值的整条记录时间:2023-03-09 09:59:07 SELECT * FROM( SELECT id,name,counts,createDate,row_number() OVER(partition BY name ORDER BY createDate DESC) rowno FROM testTable ) t WHERE t.rrowno <=1