题解 | #考试分数(五)#
考试分数(五)
http://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0512
SELECT a.id,a.job,a.score,a.id2
from
(
select id,job,score,
CAST(row_number() over(partition by job order by score asc) as signed) as 'id1',
CAST(row_number() over(partition by job order by score desc) as signed) as 'id2'
from grade
) as a
where a.id1=a.id2 or ABS(a.id1-a.id2)=1
ORDER BY id
查看24道真题和解析