请教分析函数

[lixinbill]

哪位大侠了解分析函数,举个例子或讲解一下,多谢

[gxjwqm]

sf

[gxjwqm]

select id,mc,sl,
min(mc) keep (DENSE_RANK first ORDER BY sl) over(partition by id),
max(mc) keep (DENSE_RANK last ORDER BY sl) over(partition by id)
from test
;

[gxjwqm]

select id,dense_rank() over(partition by id order by score desc) rk,score from students;

[lixinbill]

我先研究下

[Richard345265669]

详细的解释一下嘛，学习了

[b11ght]

这么明显的到分，你技术含量也太低了。