1.sqlserver
首先看看sqlserver的分页原理
例:10到20的数据分页
SELECT top 10 *
from tablename
where
id not in (
select top 10 id from tablename
)
order by id
在mybatis中,用pagesize,pagestart去替换10,20
SELECT top ${pagesize} *
from tablename
where
id not in (
select top ${pagestart} id from tablename
)
order by id
2.mysql的分页语句
SELECT
*
FROM css_common_config
LIMIT ${pagestart} ,${pagesize}