1:如果table1中没有唯一值得列
临时给table1加上一个identity列,查询完后再drop掉
alter table table1 add NewID int identity(1,1)
select col1,col2 from table1 where NewID>=50 and NewID<=60
alter table table1 drop column NewID
2.如果table1中col1的值唯一,也可以如下
select top 60 * from table1 where col1 not in (select top 50 col1 from table1)