select * from (
select tb.*,row_number() over(partition by name order by score desc) id from tb) t
where t.id=1;
select tb.*,row_number() over(partition by name order by score desc) id from tb) t
where t.id=1;
Select * From (
select tb.*,rank() over(partition by name order by score desc) id from tb Where ljjc>0) t
where t.id=1;
这才是求最大值的正确方法。
楼主需要通过过滤的方式求最大值是不合理的。