问题遇到的现象和发生背景
select tempPage.*
from (
select temp.*,
row_number() OVER (
ORDER BY 1 DESC
) as pageRowNo
from (
select historyofmonthsalesid,
s_uniid,
s_buyercode,
s_sellercode,
s_prodcode,
customer_orgcode,
reportmonth
from ods_sjgc.v_flow_month_sale
where customer_orgcode in ((#{code}),(#{code1}))
and SUBSTR(reportmonth, 1, 7) between '#{startTime}'
and '#{endTime}'
) temp
) tempPage
where pageRowNo between (#{offset})
AND (#{offset} + #{maxRows})
运行结果及报错内容
1.这段sql 报错
2.报错:exception.JDBC_EXECUTE_ERROR
3.我想知道,offset 和 maxRows的意思
4.这个是分页
5.传入2个code值和一个时间范围,offset 和maxRows 没搞懂