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

From Manfred Koizar
Subject Re: selecting rows based on unique fields in a column
Date
Msg-id ef0iqvcepq0durqp8e7vb8jqj726dubgok@email.aon.at
Whole thread Raw
In response to selecting rows based on unique fields in a column  (John Siggins <j-siggins@blueyonder.co.uk>)
Responses Re: selecting rows based on unique fields in a column  (John Siggins <j-siggins@blueyonder.co.uk>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: John Siggins
Date:
Subject: selecting rows based on unique fields in a column
Next
From: John Siggins
Date:
Subject: Re: selecting rows based on unique fields in a column