select t.* from
(select test.*,row_number() over (partition by classname order by score desc) rn
from test) t
where rn=1;
* 可以用于找每个客户最近一次订单信息
select t.* from
(select test.*,row_number() over (partition by classname order by score desc) rn
from test) t
where rn=1;
* 可以用于找每个客户最近一次订单信息