RE: SQL question
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <geraldine_2@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Dec 2004 17:54:46 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of geraldine_2@xxxxxxxxxxx
Sent: Friday, December 03, 2004 17:37
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
