Re: selecting rows based on unique fields in a column

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