select top 10 * from (select row_number() over(order by ID asc) as rownumber,* from T_TRAINORDERRC) temp_row where rownumber>10;
SQLserver分页查询
原文：https://www.cnblogs.com/yongguang1990/p/10223785.html
