RE: SQL question

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 3 Dec 2004 17:54:46 +0100
Message-Id: <20041203165459.E65243C364A@ha-smtp3.tiscali.nl>

 

Hi Geraldine,
What about:

SQL> select distinct a,b from t minus select b,a from t;  

Lex.  

---

Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html

---

 

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of geraldine_2_at_comcast.net
Sent: Friday, December 03, 2004 17:37
To: oracle-l_at_freelists.org
Subject: SQL question

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

--

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