[noviceforever]

I need to retrieve 3 fields from the database-firstname,lastname and emplId. There are a few errors in the data so the spellings of some firstnames are diff for same ppl(same last name) eg. Smith Jones and Smit Jones refer to the same person,but they are spelt incorrectly in one record.However,the emplIds of both are the same.
I need to retrieve only one instance of each person .i.e only either Smith jones or smit jones shud appear but not both...
i tried
select distinct emplId,namefirst,namelast from table where or='3434'
but this does not work..i get both the jones here.
Can i apply distinct to emplID ONLY?

TIA