Posted by Martijn Tonies on 08/21/07 21:20

> >> > Hello,
> >>
> >> > Suppose I have the following table...
> >>
> >> > name employeeId email
> >> > --------------------------------------------
> >> > Tom 12345 t...@localhost.com
> >> > Hary 54321
> >> > Hary 54321 h...@localhost.com
> >>
> >> > I only want unique employeeIds return. If I use Distinct it will
still
> >> > return all of the above as the email is different/missing. Is there a
> >> > way to query in SQL so that only distinct employeeId is returned? no
> >> > duplicates.
> >>
> >> > I wouuld like to say WHERE no blank fields are present to get the
> >> > right row to return.
> >>
> >> > Many thanks
> >>
> >> > Yas
> >>
> >> Which row for Hary do you want to be returned? The one without an
> >> email address or the one with the email address?
> >
> > basically 1 that doesn't have any fields missing....
> >
> > cheers
> >
>
> SELECT * from table where name<>"" and employeeId<>0 and email<>"";

Just a note:

Please, no double quotes for string constants, use single quotes.

Double quotes are reserved for "delimited identifiers" as defined by the
SQL Standard and supported by MS SQL Server.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

[Back to original message]