Oracle先分组查询，后取出各个分组的前10条数据

select t.name,t.gender,t.score from 
(select y.name,y.gender,h.score,row_number() 
over(partition by y.name order by y.name asc) rn 
from student y ,student_score h 
where y.id = h.student_id and y.gender is not null and y.gender in ('male')
group by y.name,y.gender,h.score) t 
where rn <= 10;