各位大哥请帮忙 用一个select 与句选出从n行到m行怎么写？
我想用select 选择一部分记录，请教个位大哥怎么实现。
谢谢！！
问题点数：5、回复次数：5Top
1 楼xeqtr1982（Visual C# .NET）回复于 2006-06-01 11:47:37 得分 0
--例子
declare @t table(id int,a varchar(10))
insert into @t select 2,'3rw3313'
insert into @t select 1,'fer33113'
insert into @t select 4,'3rw3r133'
insert into @t select 3,'33e313'
insert into @t select 7,'rw3313'
insert into @t select 8,'33rw13'
insert into @t select 11,'3r3r3'
--3-5行
select [id_t]=identity(int,1,1),* into # from @t
select id,a from (select top 3 * from (select top 5 * from # order by id_t)a order by id_t desc)b order by b.id_t
select id,a from # where id_t between 3 and 5
drop table #
Top
2 楼CNNO01（）回复于 2006-06-01 11:48:54 得分 0
select top m* from (select top (m-n)* from table order by 名称）bTop
3 楼fire_qu（金迷之蓝色忧郁）回复于 2006-06-01 12:33:49 得分 0
学习INGTop
4 楼sunzhaohui03（黑暗散尽，初露光芒）回复于 2006-06-01 12:45:24 得分 0
谢谢各位：我想取第n行到第m行
Top
5 楼YWarm（）回复于 2006-06-01 13:11:54 得分 0
没明白你的意思哦
select * from @t where id>=3 and id<=5 --如果id能设成主键
如果不行的话就你自己的那段语句也就可以了啊Top
