怎样支持这种操作... LIMIT 10 OFFSET 1

lingaiguo 2006-01-10 01:08:51

取特定范围的结果..

从第11条到第20条记录..怎样实现...

...全文

262 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

lw1a2 2006-01-10

打赏
举报

Sybase里有LIMIT 10 OFFSET 1 ？

lingaiguo 2006-01-10

打赏
举报

没排序的字段.LIMIT 10 OFFSET 1 不用order by

lw1a2 2006-01-10

打赏
举报

总有个用来排序的字段吧

lingaiguo 2006-01-10

打赏
举报

你这种方式是取前20 和后10条.如果现有表中没有记录自增的字段是何办法?

select * from table LIMIT 10 OFFSET 1
select * from table LIMIT 10 OFFSET 11

???

lw1a2 2006-01-10

打赏
举报

create table #t(id numeric(10,0) identity,v int)
go
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)
insert into #t(v) values(1)

set rowcount 20
select * into #t2 from #t order by id
set rowcount 0

set rowcount 10
select * from #t2 order by id desc
set rowcount 0