mysql
SELECT <include refid="VoucherInfo.columns"/>
FROM (
SELECT m.*, (@rownum:=@rownum+1) as rnum
FROM
(SELECT DISTINCT <include refid="VoucherInfo.columnsForPage"/> FROM VOUCHER_INFO A, VOUCHEmysqlR_INFO_LST B
<include refid="VoucherInfo.findPage.where"/>
) m ,(SELECT (@rownum:=0)) s
ORDER BY VOUCHER_DATE DESC
)t
WHERE t.rnum >= #startNum# AND t.rnum <#endNum#
oracle
在这里插入代码片