From: | Karl Denninger <karl(at)denninger(dot)net> |
---|---|
To: | chester c young <chestercyoung(at)yahoo(dot)com> |
Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: SQL question.... |
Date: | 2008-05-20 19:17:34 |
Message-ID: | 483323CE.7090200@denninger.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
chester c young wrote:
>> create table access (name text, address ip)
>>
>> I want to construct a SELECT statement which will return ONLY tuples
>> containing IP and name pairs IF there is an IP that has two or more
>> NAMEs associated with it.
>>
>>
>>
>
> many ways:
>
> select a1.* from access a1 where exists(
> select 1 from access a2 where a2.name=a2.name and a1.ip!=a2.ip );
>
> select a1.*
> from access a1
> join access a2 using( name )
> where a1.ip != a2.ip;
>
>
Those will return single entries as well (which is easy to do with an
"ORDER BY", that is computationally simpler)
What I want (and can't figure out) is a SELECT that returns ONLY tuples
with two or more NAME entries that have the same IP.
-- Karl
From | Date | Subject | |
---|---|---|---|
Next Message | Harold A. Giménez Ch. | 2008-05-20 19:54:11 | Re: SQL question.... |
Previous Message | chester c young | 2008-05-20 19:06:32 | Re: SQL question.... |