Delete duplicate from a table

[Ielamrani]

Hi,
I have a table with data like this:

LastNm FirstNm
Smith John
Jordan Al
Jordan Al
Sheriff Ahmed
Sheriff Ahmed

I would like to eliminate duplicates from a table and keep only one record for each person.

The query would give me the following:

LastNm FirstNm
Smith John
Jordan Al
Sheriff Ahmed

Thanks

Ismail

 

[PHV]

SELECT DISTINCT LastNm, FirstNm
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

Thank you very much...
Sorry I did mention this in my previous question...
I am trying to add other colums (Like ProspectKey, Street, Apt, Zip etc..)but the duplicate are still there..

I put the following:
SELECT DISTINCT LastNm, FirstNm, ProspectKey, Street, Apt, Zip, Phone
FROM tblInfo

Thanks

 

[PHV]

Perhaps something like this (getting mixed infos from dups ...):
SELECT LastNm, FirstNm, Max(ProspectKey), Max(Street), Max(Apt), Max(Zip), Max(Phone)
FROM tblInfo
GROUP BY LastNm, FirstNm

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=5721

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

Perfect, Thank you very much
Ismail