摘要：窗口函数累加递增 select a.OrderNum,a.num,a.CreateTime,b.audittime, sum(a.num) over(order by a.OrderNum range between unbounded preceding AND CURRENT ROW) as c 阅读全文

摘要：select * from T_YW_Gongdan order by GDCodeoffset 660 rowsfetch next 11 rows only Offset跳过前面的660条数据 fetch next 获取接下来的11条数据 可以用来实现分页获取数据 Sql 2012后支持 阅读全文