Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to delete Duplicate data from database?

Status
Not open for further replies.
nowayout

nowayout

Programmer
Feb 25, 2003
364
0
0
US
Hi all,

Pleae help me herep.. I have duplicate data in my database and i want to keep one copy of that and delete one i mean i want to delete duplicate data from database

Suggestion?
thanks
 
Sort by date Sort by votes
Hi,

Take a distinct of your table and put it in a temperory table. Truncate the main table and and the load the data back from temp table

Regards,
Vish
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
204
Chris Miller
Chris Miller
bharons
  • Question
Pick up value from combobox
Replies
0
Views
140
bharons
bharons
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
121
Andrzejek
Andrzejek
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
141
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
166
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top