Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
rownumber
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Suppose you have duplicate rows in a table. How can you delete all duplicates but keep one copy using SQL only?
Sachin Ghatage
Sachin Ghatage
Sachin Ghatage
Follow
Oct 12 '25
Suppose you have duplicate rows in a table. How can you delete all duplicates but keep one copy using SQL only?
#
sql
#
rownumber
Comments
Add Comment
1 min read
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account
