how to delete duplicate rows from a table?

Question

how to delete duplicate rows from a table?

Answer 1

In Access,

- Create a query, group by a field to find duplicate rows. Count it!

- Create another query, to delete a record by field (in first query).



Sorry, if you want more, please sent to me your mdb, and details information, I think i can help u!

Answer 2

Look at your toolbar in Microsoft Word. There you will find the word "Table" click on it. Here you can insert a table of your choice. If you have chosen too many rows just highlight the entire row that you would desire to delete and go back to the word "Table" on the toolbar and click, you will the see the word "Delete" Ah that's your answer. Click on Delete and there you have it one row less than before or as many as you choose to delete. Fun huh?

Answer 3

if ur quetions pertains to sqlserver then this is the way u delete the duplicate rows in a table by makenig use of "distinct" word

select distinct job from emp

duplicate values will not be allowed

Answer 4

In excel? click on row letter or number and click delete.

Answer 5

provide more information please , are you working with MS_ACCESS, VB..... there are so many ways to do that.