Unique Results Only 1

[CzechNET]

I have a query like this:

SELECT fldUSERNAME, fldPASSWORD, fldNAME, fldEMAIL FROM MY_TABLE

Now I'm trying to return only those records with a unique email addres, so no email address would be repeated twice.
How would I go about it, somehow use the GROUP BY ?

 

[r937]

select fldUSERNAME
     , fldPASSWORD
     , fldNAME
     , fldEMAIL 
  from MY_TABLE as foo
 where 1 
     = ( select count(*)
           from MY_TABLE
          where fldEMAIL 
              = foo.fldEMAIL )

this is probably not what you really want, but it is exactly what you asked for



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[CzechNET]

Thanks Rudy I think it's exactly what I was after, it gives me the fields I need but only form records that have a unique email address. Thanks.