摘要:
1.select*from ( select row_number()over(orderby tempColumn)tempRowNumber,*from (selecttop 开始位置+10 tempColumn=0,*from Table1)t )tt where tempRowNumber>开始位置2.selecttop10*from Table1 where Id>(selectmax(Id) from (selecttop 开始位置 Id from Table1order by Id)tt)3.selecttop10*from Table1 where Id notin 阅读全文