sql语句分页查询
select * from [tablename] order by colname desc offset 要跳过的行数(一般是pagenum x pagesize) rows fetch next 要读取的行数(一般是pagesize) rows only
例如:
select * from [user] order by id desc offset 40 rows fetch next 20 rows only
读取user表id倒序后41行起20行数据
网站建设、淘宝、域名主机等相关经验分享
select * from [tablename] order by colname desc offset 要跳过的行数(一般是pagenum x pagesize) rows fetch next 要读取的行数(一般是pagesize) rows only
例如:
select * from [user] order by id desc offset 40 rows fetch next 20 rows only
读取user表id倒序后41行起20行数据