Yep, in fact, I'm not sure the WHERE manages to do anything here, I think it's the distinct that you need. RF -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx Sent: 12/3/2004 11:03 AM Subject: RE: SQL question make it a distinct select and it works. -----Original Message----- From: Stephane Faroult [mailto:sfaroult@xxxxxxxxxxxx] Sent: Friday, December 03, 2004 11:10 AM To: oracle-l@xxxxxxxxxxxxx; geraldine_2@xxxxxxxxxxx Subject: 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@xxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l[1] --- Links --- 1 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Fora cle- l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l