|
|
Posted by Luuk on 08/21/07 13:47
"Yas" <yasar1@gmail.com> schreef in bericht
news:1187701509.682453.306820@o80g2000hse.googlegroups.com...
> 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
>
SELECT * from table where name<>"" and employeeId<>0 and email<>"";
but why would you have this second row "Hary 54321 " in your
table anyway?
would it not be better to create unique index on emplyeeId ?
Navigation:
[Reply to this message]
|