问oracle.Here (Row_num)给我的输出不同于oracle.Here中的count(*)是我的查询

EN

select count(*)
from (SELECT Instance.JOB_INSTANCE_ID,
             Instance.JOB_NAME,
             Instance.JOB_KEY,
             Execution.JOB_EXECUTION_ID,
             Execution.VERSION,
             Execution.CREATE_TIME,
             Execution.START_TIME,
             Execution.END_TIME,
             Execution.STATUS,
             Execution.EXIT_CODE,
             Execution.EXIT_MESSAGE,
             Execution.LAST_UPDATED,
             Execution.JOB_CONFIGURATION_LOCATION
      FROM (SELECT JOB_INSTANCE_ID,
                   JOB_NAME,
                   JOB_KEY
            FROM PROCESOSBATCH_OWN.BATCH_JOB_INSTANCE
            order by JOB_INSTANCE_ID) Instance,
           (SELECT JOB_EXECUTION_ID,
                   VERSION,
                   JOB_INSTANCE_ID,
                   CREATE_TIME,
                   START_TIME,
                   END_TIME,
                   STATUS,
                   EXIT_CODE,
                   EXIT_MESSAGE,
                   LAST_UPDATED,
                   JOB_CONFIGURATION_LOCATION
            FROM PROCESOSBATCH_OWN.BATCH_JOB_EXECUTION
            WHERE 1 = 1
            order by JOB_INSTANCE_ID) Execution
      where Instance.JOB_INSTANCE_ID=Execution.JOB_INSTANCE_ID
      and Execution.JOB_INSTANCE_ID is not null);

  COUNT(*)
----------
      9689

select max(row_num)
from (SELECT Execution.row_num,
             Instance.JOB_INSTANCE_ID,
             Instance.JOB_NAME,
             Instance.JOB_KEY,
             Execution.JOB_EXECUTION_ID,
             Execution.VERSION,
             Execution.CREATE_TIME,
             Execution.START_TIME,
             Execution.END_TIME,
             Execution.STATUS,
             Execution.EXIT_CODE,
             Execution.EXIT_MESSAGE,
             Execution.LAST_UPDATED,
             Execution.JOB_CONFIGURATION_LOCATION
      FROM (SELECT JOB_INSTANCE_ID,
                   JOB_NAME,
                   JOB_KEY
            FROM PROCESOSBATCH_OWN.BATCH_JOB_INSTANCE
            order by JOB_INSTANCE_ID) Instance,
           (SELECT rownum as row_num,
                   JOB_EXECUTION_ID,
                   VERSION,
                   JOB_INSTANCE_ID,
                   CREATE_TIME,
                   START_TIME,
                   END_TIME,
                   STATUS,
                   EXIT_CODE,
                   EXIT_MESSAGE,
                   LAST_UPDATED,
                   JOB_CONFIGURATION_LOCATION
            FROM PROCESOSBATCH_OWN.BATCH_JOB_EXECUTION
            WHERE 1 = 1
            order by JOB_INSTANCE_ID) Execution
      where Instance.JOB_INSTANCE_ID=Execution.JOB_INSTANCE_ID
      and Execution.JOB_INSTANCE_ID is not null);

MAX(ROW_NUM)
------------
        9854