取出表A中第31到第40记录
摘要：
方法一： select top 10 * from A where RowId not in (select top 10 RowId from A)方法二（使用临时表）： with tempTable as (select row_number()over(order by RowId) as newRowId,* from A) select * from tempTable where newRowId between 31 and 40 阅读全文
posted @ 2014-02-16 10:09 骑蟋蟀的蝈蝈 阅读(371) 评论(0) 推荐(0) 编辑
