how to delete duplicate record in a table by using SQL query
g.prabu
0
Newbie Poster
Recommended Answers
Jump to Posthow to delete duplicate record in a table by using SQL query
duplicate of what? all duplicates? why don't you have a unique identifier? do you have any validation? why are you here? why am i answering you?
Jump to Posthow to delete duplicate record in a table by using SQL query
I also faced the same kind of problem and solved it by myself as I never got good source.
I guess you have a table that has duplicate records but still you can identify them with a unique …
Jump to PostHi,
You can find methods summarized with samples at the article named "How to delete duplicate records or rows among identical rows in a table where no primary key exists" at http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx
…
Jump to PostHi,
I registered just to thank you for this amazing article.
The query using the identity is simple and elegant!
Thanks a lot.
PinoHi,
You can find methods summarized with samples at the article named "How to delete duplicate records or rows among identical rows in a …
All 15 Replies
pty
882
Posting Pro
g.prabu
0
Newbie Poster
arunendra
0
Newbie Poster
eralper
0
Newbie Poster
puppinoo
0
Newbie Poster
bsasiju
0
Newbie Poster
rado
0
Newbie Poster
Nabi_Ahmad
0
Newbie Poster
mohammeds
0
Newbie Poster
puneetkay
40
Junior Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
space1000
0
Newbie Poster
edgarkuhimbisa
0
Newbie Poster
gauravshar
0
Newbie Poster
msi
-2
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.