by Madan Patil – This script will remove duplicate rows. Even if you suppose one record is duplicated more than 2 times, the script will keep only one record and delete the others.
The advantage of this script is that if you have loaded data from SQL*LOADER or from other databases or data imp
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help