Oracle分析函数-rank() over(partition by...order by...)

1. select *from (
   SELECT
   t.s#,---学号
   t.c#,---课程号
   T.SCCORE, ---成绩
   RANK() OVER(PARTITION BY t.c#  ORDER BY t.sccore DESC ) AS rk,
   FROM scc t) mm
   where rk<=1