用SQL怎么查出前50条数据的后20条数据和前30条数据
0
最佳答案
1
select top 30 * from table where id in (select top 50 id from table order by id asc)
select top 20 * from table where id in (select top 50 id from table order by id desc)
