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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can i get password for a database 1
How to get a value from 1 table to a 2nd. 15
Creating a Chart on form from selected data in query. 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Access 2016 Queries 0
Duplicates Deletion ? 2
Delete duplicate rows without deleting entire row 1
Excel to Word to PDF workflow 1

Top