RE: SQL question

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_at_freelists.org
To: oracle-l_at_freelists.org
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_at_roughsea.com] Sent: Friday, December 03, 2004 11:10 AM To: oracle-l_at_freelists.org; geraldine_2_at_comcast.net 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_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]

• Links --- 1 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Fora cle- l
  --
  http://www.freelists.org/webpage/oracle-l
  --
  http://www.freelists.org/webpage/oracle-l
  --
  http://www.freelists.org/webpage/oracle-l