Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Corrected SQL Question...
I think those solutions should be acceptable.
Not sure if they are displaying any more information from the table. I was just given the test table to get the SQL script working....
Thanks a lot.
-----Original Message-----
Sent: Thursday, March 13, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
I think its easier if you do it cross-tab
AUS DAL DAL AUS
Is that acceptable?
Or just select
AUS DAL If it also has a DAL AUS
Are either of those metods acceptable? If so, pick one and Ill show you how to do it.
>
> From: "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
> Date: 2003/03/13 Thu AM 11:19:15 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Corrected SQL Question...
>
> Okay, let me do this right this time,... (Now that I have my hot tea going;)
>
> Here is the test data:
>
> SQL> select c1,c2 from cp;
>
> C1 C2
> --- ---
> AUS DAL
> AUS HOU
> DAL AUS
> DAL HOU
> DAL LIT
> DAL XYZ
> HOU AUS
> HOU DAL
> HOU LIT
> HOU XYZ
> LIT DAL
>
> C1 C2
> --- ---
> LIT HOU
> XYZ DAL
> XYZ HOU
>
> 14 rows selected.
>
> SQL>
>
> Here is what is required:
>
> C1 C2
> --- ---
> AUS DAL
> DAL AUS
> AUS HOU
> HOU AUS
> DAL HOU
> HOU DAL
> DAL LIT
> LIT DAL
> DAL XYZ
> XYZ DAL
> HOU LIT
> LIT HOU
> HOU XYZ
> XYZ HOU
>
>
> I think I am clear now...
> Sorry about the wrong test data earlier...
>
>
> Thanks,
>
> - Kirti
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Mar 13 2003 - 11:49:28 CST
![]() |
![]() |