how to delete duplicates

J

jaffar

hai,

i am using a table in sqlserver, table name is sample1,

fields are
ename varchar(20)

in this table there are 4 names

i.e

jaffar
jaffar
jaffar
jaffar

i want to delete last filed value i.e i want to delete last jaffar from the
table

i want result as

jaffar
jaffar
jaffar


what is the query for that,



warm regards
jaffar ali
 
Top