mssql2005后基于row_number()的分页语句
程序员文章站
2022-04-22 08:33:12
...
select x.id,x.name from (select ROW_NUMBER() over(order by id) as rowNum,* from xx) as x where x.rowNum >0 and x.rowNum <=1000
上一篇: mybatis向动态表名,动态属性表中插入数据,更新数据
下一篇: 深入浅出数据库连接池c3p0