Question10: How can I list non-contignous data? In database pubs, I create a table test u
Question10: How can I list non-contignous data?
In database pubs, I create a table test using statement as below, and I
insert several row as below
create table test
(id int primary key )
go
insert into test values (1 )
insert into test values (2 )
insert into test values (3 )
insert into test values (4 )
insert into test values (5 )
insert into test values (6 )
insert into test values (8 )
insert into test values (9 )
insert into test values (11)
insert into test values (12)
insert into test values (13)
insert into test values (14)
insert into test values (18)
insert into test values (19)
go
Now I want to list the result of the non-contignous row as below,how can I
do it?
Missing after Missing before
------------- --------------
6 8
9 11
...