mybatis，sqlserver分页

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}