oracle 分頁語句

SELECT *
  FROM (SELECT tt.*, ROWNUM AS rowno

          FROM (  
                SELECT t.vin_mt ,dbxx
                    FROM {PdaCommonAppService.PREFIX}v_pj_dygx t
                    WHERE vin_jj like '%{input.vin_jj}%' and
                    dbxx BETWEEN TO_DATE ('{input.StartTime:yyyyMMdd}', 'yyyyMMdd') AND TO_DATE('{input.EndTime:yyyyMMdd}', 'yyyyMMdd')
                    ORDER BY dbxx DESC) tt

         WHERE ROWNUM <= {input.SkipCount + input.Length}) table_alias

 WHERE table_alias.rowno > {input.SkipCount}