题解 | #考试分数(四)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select job,case when max(t.s)%2=0 then round(max(s)/2,0) else round((max(s)+1)/2,0) end as start,
case when max(t.s)%2=0 then round(max(s)/2+1,0) else round((max(s)+1)/2,0) end as start
from (select job,row_number()over(partition by job order by score) s from grade) t
group by t.job
case when max(t.s)%2=0 then round(max(s)/2+1,0) else round((max(s)+1)/2,0) end as start
from (select job,row_number()over(partition by job order by score) s from grade) t
group by t.job
查看8道真题和解析