原始数据
目标结果
sql语句:
select id,name,score
from syj s1
where
score>=
(
select score from
(
select name,score
from syj
order by name,score desc
) c
where c.name=s1.name limit 1,1
)