select * from tablename where (id not in (select top 40 id from tablename order by id)) and id in (select top 50 id from tablename order by id) 这样就能实现前41-50条数据
实现前41-50条数据
最新推荐文章于 2023-10-16 08:50:42 发布
select * from tablename where (id not in (select top 40 id from tablename order by id)) and id in (select top 50 id from tablename order by id) 这样就能实现前41-50条数据