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

   
   
   

转载于:https://www.cnblogs.com/xinfang520/p/7684628.html