Re: selecting rows based on unique fields in a column - Mailing list pgsql-novice

Manfred Koizar wrote:
> On Wed, 05 Nov 2003 11:52:30 +0000, John Siggins
> <j-siggins@blueyonder.co.uk> wrote:
>
>>  select reqitem from lasting
>>group by reqitem having count(reqitem) = 1;
>>
>>But this gives me only reqitem column and I want the rest of the row!
>
>
> SELECT l.*
>   FROM lasting AS l INNER JOIN (
>        SELECT reqitem FROM lasting
>         GROUP BY reqitem HAVING count(reqitem) = 1
>        ) AS x ON l.reqitem = x.requitem;
>
> Servus
>  Manfred
Thanks v much
    This seems to works a treat. Your method and Michael's return the same
no of rows so both methods look good to me.

John