Thank this author by sharing:
By Shankar Walvekar, 2012/11/20
Steps to use the script:
1. Create table using the given code
2. Insert duplicate records into the table
3. Select the records that you want to see.
4. Delete duplicate records
Table records
delete records
duplicate records
output the duplicate records
select random records
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
