SQLServer查询数据加一列序号

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}