SELECT DISTINCT
       STUDENTS_number,
       SUBJECT_NAME,
       EXAMINATION_DATE,
       :START_DATE,
       :END_DATE class_name,
       MAX_ARCH,
       SUBJECT_TEACHER,
       total_seated_candidates,
       notes,
       DENSE_RANK ()
          OVER (PARTITION BY class_name, SUBJECT_NAME ORDER BY MAX_ARCH DESC)
          RANK,
       DENSE_RANK ()
       OVER (PARTITION BY class_level, SUBJECT_NAME ORDER BY MAX_ARCH DESC)
          RANK
  FROM dmss_STUDENTS_REPORT
 WHERE     EXAMINATION_DATE BETWEEN :START_DATE AND :END_DATE
       AND EXAMINATION_DATE >= :START_DATE
       AND EXAMINATION_DAte <= :END_DATE
       AND EXAMINATION_TYPE = :EXAMINATION_TYPE
       AND STUDENTS_NUMBER = :STUDENT_NAME