在xml配置文件中
select top ${pageSize} * from 表名 where id not in (select top ${pageSize}*(#{page}-1) id from 表名 order by id) order by id
在xml配置文件中
select top ${pageSize} * from 表名 where id not in (select top ${pageSize}*(#{page}-1) id from 表名 order by id) order by id