Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> nice sql problem

nice sql problem

From: Ronald <devnull_at_ronr.nl>
Date: 29 Jan 2002 04:42:23 -0800
Message-ID: <67ce88e7.0201290442.2bd6ad09@posting.google.com>


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.



http://ronr.nl/unix-dba Received on Tue Jan 29 2002 - 06:42:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US