SELECT * FROM
                    ( SELECT STUDENTID, SUBJECTCODE, SUBJECTNAME, STUDYPROGRAMNAME, SCHOOLPERIODE, INDEXPOINT, SUBJECTID, COURSESTUDYPROGRAMID, TOTALCHANGE, ACTIVESTATUS, ACTIVESTATUS1, EVIDANCEURL, ROWNUM rnum,TOTALROWS FROM
                    (
                        SELECT ZZZ.*,COUNT(*) over () TOTALROWS FROM (
                            SELECT * FROM (SELECT FG.*, (FG.SCHOOLYEAR||'/'||FG.SEMESTER) SCHOOLPERIODE, C.TOTALCHANGE, C.ACTIVESTATUS1, EVIDANCEURL FROM FINALGRADE_ALL_STATUS FG
        LEFT JOIN (
            SELECT
            STUDENTID,
            SUBJECTID,
            ACTIVESTATUS AS ACTIVESTATUS1,
            EVIDANCEURL,
            SCHOOLYEAR,
            SEMESTER,
            COUNT( STUDENTID ) TOTALCHANGE
        FROM
            COMPLETECOURSEPOINTCHANGE
        WHERE
            APPROVALSTATUS IS NULL
        GROUP BY
            STUDENTID,
            SUBJECTID,
            SCHOOLYEAR,
            SEMESTER,
            ACTIVESTATUS,
            EVIDANCEURL
        ) C ON (FG.STUDENTID=C.STUDENTID AND FG.SUBJECTID=C.SUBJECTID AND FG.SCHOOLYEAR=C.SCHOOLYEAR AND FG.SEMESTER=C.SEMESTER)
        WHERE FG.STUDENTID = '103012380554'  )
                        )ZZZ

                    ) a
                    WHERE ROWNUM <= 20 )
                    WHERE rnum  >= 1