Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL question
select least(a, b) a,
greatest(a, b) b
from my_table
where least(a, b) <= greatest(a, b)
Assuming of course that the table isn't in the multi-million range.
Regards,
Stephane Faroult
RoughSea Ltd
http://www.roughsea.com
On Fri, 03 Dec 2004 16:37 , geraldine_2_at_comcast.net sent:
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[1]