From :
http://www.itpub.net/viewthread.php?tid=1083104&page=1#pid12057097[@more@]
关于取连续数据请教,谢谢!
drop table test;
create table test (id1 int,id2 int ,id3 int);
insert into test (id1 ,id2,id3) values (1,45,89);
insert into test (id1 ,id2,id3) values (2,45,89);
insert into test (id1 ,id2,id3) values (3,45,89);
insert into test (id1 ,id2,id3) values (8,45,89);
insert into test (id1 ,id2,id3) values (12,45,89);
insert into test (id1 ,id2,id3) values (36,45,89);
insert into test (id1 ,id2,id3) values (22,45,89);
insert into test (id1 ,id2,id3) values (23,45,89);
insert into test (id1 ,id2,id3) values (89,45,89);
insert into test (id1 ,id2,id3) values (90,45,89);
insert into test (id1 ,id2,id3) values (91,45,89);
insert into test (id1 ,id2,id3) values (92,45,89);
commit;
我要的查询结果就是查出
(1,45,89);
(2,45,89);
(3,45,89);
(22,45,89);
(23,45,89);
(89,45,89);
(90,45,89);
(91,45,89);
(92,45,89);
这些记录就好了
create table test (id1 int,id2 int ,id3 int);
insert into test (id1 ,id2,id3) values (1,45,89);
insert into test (id1 ,id2,id3) values (2,45,89);
insert into test (id1 ,id2,id3) values (3,45,89);
insert into test (id1 ,id2,id3) values (8,45,89);
insert into test (id1 ,id2,id3) values (12,45,89);
insert into test (id1 ,id2,id3) values (36,45,89);
insert into test (id1 ,id2,id3) values (22,45,89);
insert into test (id1 ,id2,id3) values (23,45,89);
insert into test (id1 ,id2,id3) values (89,45,89);
insert into test (id1 ,id2,id3) values (90,45,89);
insert into test (id1 ,id2,id3) values (91,45,89);
insert into test (id1 ,id2,id3) values (92,45,89);
commit;
我要的查询结果就是查出
(1,45,89);
(2,45,89);
(3,45,89);
(22,45,89);
(23,45,89);
(89,45,89);
(90,45,89);
(91,45,89);
(92,45,89);
这些记录就好了
select id1,id2,id3 from test where id1 in ((select id1-1 from test) union (select id1+1 from test));
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66634/viewspace-1013082/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/66634/viewspace-1013082/