SQL> select * from t;A B --- --- 001 002 002 003 003 004SQL> select substr(max(sys_connect_by_path(a, '-') || '-' || b), 2) 2 from t 3 start with a = '001' 4 connect by prior b = a;SUBSTR(MAX(SYS_CONNECT_BY_PATH(A,'-')||'-'||B),2) ----------------------------------------------------------------------------001-002-003-004
谢谢 楼上 A B --- --- 001 002 002 003 003 004 006 008 010 011 011 012我想要的结果是: A B --- --- 001 004 006 008 010 012
--- ---
001 002
002 003
003 004SQL> select substr(max(sys_connect_by_path(a, '-') || '-' || b), 2)
2 from t
3 start with a = '001'
4 connect by prior b = a;SUBSTR(MAX(SYS_CONNECT_BY_PATH(A,'-')||'-'||B),2)
----------------------------------------------------------------------------001-002-003-004
A B
--- ---
001 002
002 003
003 004
006 008
010 011
011 012我想要的结果是:
A B
--- ---
001 004
006 008
010 012