Thank this author by sharing:
By Shankar Walvekar,
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
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.