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}
{PdaCommonAppService.PREFIX} 前綴
input.SkipCount 跳過的數量
input.Length 每頁條數
Newd
版權聲明
作者:扶我起來我還要敲
地址:http://www.rzrgm.cn/Newd/p/14631956.html
? Newd 尊重知識產權,引用請注出處
廣告位
(虛位以待,如有需要請私信)
浙公網安備 33010602011771號