第一种方式
select * from(select *,ROW_NUMBER()over(order by id) as num from Goods…goods) as t where num>=20 and num<=30;
第二种方式
select top 30 * from Goods…goods
except
select top 20 * from Goods…goods
第三种方式,一定范围的数据怎么改造呢每页显示n条数据,第k页显示那些数据呢
select * from(select *,ROW_NUMBER()over(order by id) as num from Goods…goods) as t where num>=(k-1)n+1 and num<=kn;
获取数据库中的数据进行分页显示
最新推荐文章于 2023-03-22 15:55:35 发布