SELECT
    *
FROM
    (
    SELECT
/*+ FIRST_ROWS(50) */
        SITE_CODE,
        ( SELECT UNIT || ' ' || NAME FROM SITE WHERE SITE_CODE_EXIST = A.SITE_CODE AND SITE_TYPE_ID = 5 ) SITE_NAME,
        METER_CODE,
        METER_TYPE_BRAND,
        LOCATION_CODE,
        LOCATION_NAME,
        TARIFF,
        POWER,
        SUSPECT_CATEGORY,
        ROUND( VOLTAGE_L1, 2 ),
        ROUND( VOLTAGE_L2, 2 ),
        ROUND( VOLTAGE_L3, 2 ),
        ROUND( VOLTAGE_ANGLE_L1, 2 ),
        ROUND( VOLTAGE_ANGLE_L2, 2 ),
        ROUND( VOLTAGE_ANGLE_L3, 2 ),
        ROUND( CURRENT_L1, 2 ),
        ROUND( CURRENT_L2, 2 ),
        ROUND( CURRENT_L3, 2 ),
        CURRENT_N,
        ROUND( CURRENT_ANGLE_L1, 2 ),
        ROUND( CURRENT_ANGLE_L2, 2 ),
        ROUND( CURRENT_ANGLE_L3, 2 ),
        ROUND( KWH_EXPORT_TOTAL, 2 ),
        ROUND( KWH_IMPORT_TOTAL, 2 ),
        ROUND( KVARH_EXPORT_TOTAL, 2 ),
        ROUND( KVARH_IMPORT_TOTAL, 2 ),
        READ_DATE,
        ROW_NUMBER () OVER ( ORDER BY READ_DATE ASC ) RN,
        MAX( ROWNUM ) OVER ( ORDER BY NULL ) CNT
    FROM
        (
        SELECT
            SITE_CODE,
            METER_CODE,
            METER_TYPE_BRAND,
            LOCATION_CODE,
            LOCATION_NAME,
            TARIFF,
            POWER,
            SUSPECT_CATEGORY,
            VOLTAGE_L1,
            VOLTAGE_L2,
            VOLTAGE_L3,
            VOLTAGE_ANGLE_L1,
            VOLTAGE_ANGLE_L2,
            VOLTAGE_ANGLE_L3,
            CURRENT_L1,
            CURRENT_L2,
            CURRENT_L3,
            CURRENT_N,
            CURRENT_ANGLE_L1,
            CURRENT_ANGLE_L2,
            CURRENT_ANGLE_L3,
            KWH_EXPORT_TOTAL,
            KWH_IMPORT_TOTAL,
            KVARH_EXPORT_TOTAL,
            KVARH_IMPORT_TOTAL,
            READ_DATE
        FROM
            SUSPECT_INSTANTS
        WHERE
            SUSPECT_CATEGORY = '4'
            AND DATE_READ BETWEEN '20190601'
            AND '20190630'
        ) A
    WHERE
        LOCATION_CODE = '131020077926'
    )
WHERE
    RN BETWEEN ((( 1-1 ) * 100 ) + 1 )
    AND ( 1 * 100 )
ORDER BY
    RN