Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I selet rows which have 2 columns values cross equal? - Mailing list pgsql-sql

From Milorad Poluga
Subject Re: How can I selet rows which have 2 columns values cross equal?
Date
Msg-id 200603101527.41654.milorad.poluga@cores.co.yu
Whole thread Raw
In response to How can I selet rows which have 2 columns values cross equal?  ("Fay Du" <fay.du@versaterm.com>)
List pgsql-sql
Tree view 
On Friday 10 March 2006 14:24, Fay Du wrote:
>    Table test
> Id   |  a | b
> -----+----+---
> 1    | 100| 101
> 2    | 101| 100
> 3    | 100| 3
> 4    | 20 | 30
> 5    | 11 | 13
> 6    | 3  | 33
> 7    | 30 | 20
>

select a.*
from test a, test b
where a.a = b.b and a.b = b.a
order by id

Regards, Milorad Poluga

--
---------------------------------------
Milorad Poluga
HK CORES Beograd, Makenzijeva 31
milorad.poluga@cores.co.yu
---------------------------------------

pgsql-sql by date:

Previous
From: "Fay Du"
Date:
Subject: How can I selet rows which have 2 columns values cross equal?
Next
From: PFC
Date:
Subject: Re: How can I selet rows which have 2 columns values cross equal?