各位大哥,看看怎样把这种语句聚合SQL> describe tripleg
Name Null? Type
----------------------------------------- -------- ---------------------------- T# NOT NULL NUMBER(10)
LEG# NOT NULL NUMBER(2)
DEPARTURE NOT NULL VARCHAR2(30)
DESTINATION NOT NULL VARCHAR2(30)SQL>数据是这样存的INSERT INTO TRIPLEG VALUES(10, 1, 'Perth', 'Sydney');
INSERT INTO TRIPLEG VALUES(10, 2, 'Sydney', 'Brisbane');
INSERT INTO TRIPLEG VALUES(11, 1, 'Sydney', 'Melbourne');现在想输出这样的一个T# ORIGIN DESTINATION1 DESTINATION2
--------------------------------------------
10 Perth Sydney Brisbane
11 Sydney Melbourne
就是把后一个语句跟前一个做一个输出聚合,但是重复的名字只显示一次。大家帮帮忙吧
Name Null? Type
----------------------------------------- -------- ---------------------------- T# NOT NULL NUMBER(10)
LEG# NOT NULL NUMBER(2)
DEPARTURE NOT NULL VARCHAR2(30)
DESTINATION NOT NULL VARCHAR2(30)SQL>数据是这样存的INSERT INTO TRIPLEG VALUES(10, 1, 'Perth', 'Sydney');
INSERT INTO TRIPLEG VALUES(10, 2, 'Sydney', 'Brisbane');
INSERT INTO TRIPLEG VALUES(11, 1, 'Sydney', 'Melbourne');现在想输出这样的一个T# ORIGIN DESTINATION1 DESTINATION2
--------------------------------------------
10 Perth Sydney Brisbane
11 Sydney Melbourne
就是把后一个语句跟前一个做一个输出聚合,但是重复的名字只显示一次。大家帮帮忙吧
为了测试写法,增加一语句
10 1 Perth Sydney
10 2 Sydney Brisbane
11 1 Sydney Melbourne
10 1 Perth Sydney
10 2 Sydney Brisbane
11 1 Sydney Melbourne
11 2 Melbourne xiaoq --新增的语句
SQL: select a.T#,a.departure,a.destination,b.destination from
(
select distinct T#,departure,destination from test
)A
,(
select distinct T#,departure,destination from test
)B
where a.T#=b.T# and a.destination=b.departureRESULT :10 Perth Sydney Brisbane
11 Sydney Melbourne xiaoq