Posted by Yas on 08/21/07 09:04

Hello,

Suppose I have the following table...

name employeeId email
--------------------------------------------
Tom 12345 tom@localhost.com
Hary 54321
Hary 54321 hary@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

• Next in forum: Re: MS SQL dealing with duplicate columns in rows?
• Prev in forum: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
• Thread view: MS SQL dealing with duplicate columns in rows?

[Reply to this message]