题解 | #考试分数(四)#

select job, a, d
from
    (
        select
            job,
            cast(row_number() over (
                partition by
                    job
                order by
                    score
            ) as signed )a,
            cast(row_number() over (
                partition by
                    job
                order by
                    score desc
            )as signed) d
        from
            grade
    ) as rk
where a=d or abs(d-a)=1 and a<d

正序反序相同或者差值为1，就是中位数