Posted by Yas on 08/21/07 13:05

On 21 Aug, 11:20, stephen <m0604...@googlemail.com> wrote:
> On Aug 21, 10:04 am, Yas <yas...@gmail.com> wrote:
>
>
>
> > 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

• Next in forum: Re: MS SQL dealing with duplicate columns in rows?
• Prev in forum: Merge replication: How to avoid duplicates of records?
• Thread view: Re: MS SQL dealing with duplicate columns in rows?

[Reply to this message]