SELECT DENSE_RANK() OVER(ORDER BY FENSHU DESC) RK,T.* FROM STUDENT_RESULT T
SELECT DENSE_RANK() OVER(ORDER BY T.PARENTCODE DESC) RK,T.* FROM TCODE.T_COD_REGION T
SELECT DENSE_RANK() OVER(ORDER BY T.PARENTCODE DESC) RK,T.* FROM TCODE.T_COD_REGION T