ROW_NUMBER()基本用法：

　  按nenterSchScore列的值大小进行排序

　select id,sStudentCode,nEnterSchScore,row_number() over(order by nenterSchScore) as Num from V_BS_StudentScore

　   结果

　　

　用sStudentCode分割后，按nenterSchScore列的值大小进行排序

select id,sStudentCode,nEnterSchScore,row_number() over(partition by sStudentCode order by nenterSchScore) as Num from V_BS_StudentScore

      结果

　　

      RANK()基本用法：

　　按nenterSchScore列的值大小进行排序

select id,sStudentCode,nEnterSchScore,rank() over(order by nEnterSchScore) as num from V_BS_StudentScore

 　　运行结果

　　

       DENSE_RANK()基本用法：

　　按nenterSchScore列的值大小进行排序

select id,sStudentCode,nEnterSchScore,DENSE_RANK() over( order by nEnterSchScore desc) as num from v_bs_studentScore

　　运行结果