Home > Uncategorized > Remove duplicate records in T-SQL

Remove duplicate records in T-SQL

Here’s nice quick way to remove duplicate records in T-SQL

--add identity row to table
ALTER TABLE myTable add rowid int identity(1,1)
---Delete Dups From myTable
delete from myTable
where rowid not in
(select min(rowid)
from myTable
group by something)
--remove identity row from table
ALTER TABLE myTable DROP COLUMN rowid

source: http://cfsilence.com/blog/client/index.cfm/2007/3/19/TSQL–Deleting-Duplicate-Rows-From-A-Table

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: