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

Home -> Community -> Mailing Lists -> Oracle-L -> SQL question

SQL question

From: <geraldine_2_at_comcast.net>
Date: Fri, 03 Dec 2004 16:37:29 +0000
Message-Id: <120320041637.7352.41B09649000B429F00001CB82207001641CDA10A02070B040E9D0A09@comcast.net>


Hi,
I have the following table below

SQL> select * FRom mytable;

        A B
---------- ----------

         1          2
         3          4
         2          1
         5          6
         4          3

5 rows selected.

and I like to get the following output:

        A B
---------- ----------

         1          2
         3          4
         5          6
        

basically (1,2) is the same as (2,1) and I would just like to display any of those combination just once.

Not sure how I can write a SQL to extract the data. Can someone help.

TIA. Geraldine

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 03 2004 - 10:38:30 CST

Original text of this message

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