select * from (
SELECT ROW_NUMBER() OVER (ORDER BY 单号) AS rowno,* FROM(
表名或查询语句
) as a
where 1=1 ${if(len(daima) == 0,"","and 客户代码 like '%" + daima + "%'")}
) as b where b.rowno between 20*(${page}-1)+1 and 20*${page}
SELECT ROW_NUMBER() OVER (ORDER BY 单号) AS rowno,* FROM(
表名或查询语句
) as a
where 1=1 ${if(len(daima) == 0,"","and 客户代码 like '%" + daima + "%'")}
) as b where b.rowno between 20*(${page}-1)+1 and 20*${page}