oracle数据库处理分页

<div class="line number1 index0 alt2" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">您好：oracle查询分页可分为两种情况，一种使用的是rownum ，另外一种则是使用 row_number() over(</code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">order</code> <code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">by</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">column_name </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">desc</code><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">)。</code></div><div class="line number2 index1 alt1" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">1.使用rownum分页查询，可用以下方式：</code></div><div class="line number3 index2 alt2" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">select</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t2.* </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">from</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">(</code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">select</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t1.*,rownum </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">as</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">rn </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">from</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">table_name t1 </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">where</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">1=1 </code><code class="sql color1" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: gray !important; background: none !important;">and</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">rownum <= page * page_size) t2 </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">where</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t2.rn > (page - 1) * page_size;</code></div><div class="line number4 index3 alt1" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">2.使用 row_number() over() 分页查询</code></div><div class="line number5 index4 alt2" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">select</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t2.* </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">from</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">(</code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">select</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t1.*,row_number() over(</code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">order</code> <code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">by</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">column_name </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">desc</code><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">)  </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">as</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">rn </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">from</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">table_name t1 </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">where</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">1=1 )t2 </code><code class="sql keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">where</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t2.rn > (page-1)* page_size </code><code class="sql color1" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: gray !important; background: none !important;">and</code> <code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">t2.rn <= page * page_size;</code></div><div class="line number6 index5 alt1" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">这种方式，也是可以分页的。</code></div><div class="line number7 index6 alt2" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; line-height: 14.3px; font-size: 13px; color: rgb(51, 51, 51); border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(245, 245, 245); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;"><code class="sql plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">希望能帮助您！</code></div>