create table test
(ID int)
insert test (id)
select 1 union all
select 2 union all
select 3 union all
select 7 union all
select 8 union all select 9 union all
select 10 union all
select 11 union all
select 12 union all
select 18 union all select 19 union all
select 20 union all
select 22 union all
select 24 union all
select 30 --select * from test--求一SQL语句,要求:直接取出这些数据中的第N至M条,例如取第5-10条,即是
select top 6 * from test where id not in(select top 5 id from test)drop table test
(ID int)
insert test (id)
select 1 union all
select 2 union all
select 3 union all
select 7 union all
select 8 union all select 9 union all
select 10 union all
select 11 union all
select 12 union all
select 18 union all select 19 union all
select 20 union all
select 22 union all
select 24 union all
select 30 --select * from test--求一SQL语句,要求:直接取出这些数据中的第N至M条,例如取第5-10条,即是
select top 6 * from test where id not in(select top 5 id from test)drop table test
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货