SELECT
    *
FROM
    (
    SELECT
        STUDENTID,
        SUBJECTCODE,
        SUBJECTNAME,
        STUDYPROGRAMNAME,
        SCHOOLPERIODE,
        INDEXPOINT,
        SUBJECTID,
        COURSESTUDYPROGRAMID,
        TOTALCHANGE,
        ACTIVESTATUS,
        ROWNUM rnum,
        TOTALROWS
    FROM
        (
        SELECT
            ZZZ.*,
            COUNT( * ) over ( ) TOTALROWS
        FROM
            (
            SELECT
                *
            FROM
                (
                SELECT
                    FG.*,
                    ( FG.SCHOOLYEAR || '/' || FG.SEMESTER ) SCHOOLPERIODE,
                    C.TOTALCHANGE,
                    C.ACTIVESTATUS
                FROM
                    FINALGRADE FG
                    LEFT JOIN (
                    SELECT
                        STUDENTID,
                        SUBJECTID,
                        ACTIVESTATUS,
                        SCHOOLYEAR,
                        SEMESTER,
                        COUNT( STUDENTID ) TOTALCHANGE
                    FROM
                        COMPLETECOURSEPOINTCHANGE
                    WHERE
                        APPROVALSTATUS IS NULL
                    GROUP BY
                        STUDENTID,
                        SUBJECTID,
                        SCHOOLYEAR,
                        SEMESTER,
                        ACTIVESTATUS
                        ) C ON (
                        FG.STUDENTID = C.STUDENTID
                        AND FG.SUBJECTID = C.SUBJECTID
                        AND FG.SCHOOLYEAR = C.SCHOOLYEAR
                        AND FG.SEMESTER = C.SEMESTER
                    )
                WHERE
                    FG.STUDENTID = '1101130009'
                )
            ) ZZZ
        ) a
    WHERE
        ROWNUM <= 20
    )
WHERE
    rnum >= 1