postgresql 分页模板
limit #{size} offset #{size} * (#{page} - 1)
mysql 分页模板
SELECT * FROM product WHERE ID > =(select id from product limit {size}*(#{page} - 1)
, 1) limit #{size}
oracle分页模板
select *
from (select ROWNUM rowno, a.*
from (select *
from (
)
where ROWNUM <= #{size} * #{page}) a) b
where b.rowno > #{size} * (#{page} - 1)