一条很 巧妙的 SQL 语句

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);

这些记录就好了

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/