use tempdb

go

if exists (select * from sysobjects where type = 'U' and name = 'test')

drop table test

create table test(num int, n1 int, n2 int, n3 int)

go

insert into test values (1, 3, 7, 8)

insert into test values (2, 1, 9, 12)

insert into test values (3, 7, 9, 11)

insert into test values (4, 14, 15, 16)

select * from test

go

select t1.n1, t1.n2, t1.n3, t2.n1, t2.n2, t2.n3

from test t1 join test t2

on t1.num = t2.num - 2

아이고..틀렸네... 다시 이렇게...

select t1.n1, t1.n2, t1.n3, t2.n1, t2.n2, t2.n3

from test t1 join test t2

on t1.num = t2.num - 1

and t2.num%2 = 0