Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> nice sql problem
given table contains
select * from z;
A B
---------- ----------
1 2 2 3 3 4 7 8 8 10 12 13 wanted output should contain A B
---------- ----------
1 4 7 10 12 13
how ? in plain sql - no plsql.
select min(a) a, max(b) b
from z
connect by prior b = a
start with a = 1
/
A B
---------- ----------
1 4
is not complete. Any suggestions ?
tnx,
Ronald.
![]() |
![]() |