RE: SQL question

  • From: "Guang Mei" <gmei@xxxxxxxxxx>
  • To: <sfaroult@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <geraldine_2@xxxxxxxxxxx>
  • Date: Fri, 3 Dec 2004 12:06:55 -0500

I think you need to put "distinct" before "least(a, b) a,"

Guang

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephane Faroult
Sent: Friday, December 03, 2004 12:10 PM
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%2Foracle-
l
--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Other related posts: