query only outer range
474007Dec 2 2006 — edited Aug 4 2008Hi,
I have a input table
INPUT
1
2
3
5
7
8
9
11
12
13
15
17
18
20
21
22
23
and i want only the following numbers:
OUPUT
1
3
5
7
9
11
13
15
17
18
20
23
As you see i want only the number from the outer range. Can this be done with without plsql?
Greetings