select z.a,z.b,z.c
from (select lag(t.a,2)over(order by t.a) pp_val,
lag(t.a,1)over(order by t.a) p_val,
t.a,
lead(t.a,1)over(order by t.a) n_val,
lead(t.a,2)over(order by t.a) nn_val,
t.b,t.c from test2 t) z
where z.a = '1'
and ((z.p_val = '1' and z.pp_val = '1')
or (z.p_val = '1' and z.n_val = '1')
or (z.n_val = '1' and z.nn_val = '1'));
posted on 2007-07-17 16:55
kebo 閱讀(231)
評論(0) 編輯 收藏 所屬分類:
oracle