SELECT * from ( select *,ROW_NUMBER() over(order by id desc) as rowno from news) as mytable where rowno between 5 and 7
分页,数据库分页功能 SqlServer
最新推荐文章于 2022-10-27 22:48:20 发布
SELECT * from ( select *,ROW_NUMBER() over(order by id desc) as rowno from news) as mytable where rowno between 5 and 7