S cenario: I have accumulated data into SQL Server database from three different servers (oracle, O2 and oracle) for a financial reporting. After data accumulated , we found more duplicate rows; business requirement was to remove all duplicate rows because of final data will be import to another system. For this purpose, I want to write script to find out duplicate rows from my table. Finally, I want to delete only duplicate rows not original row. Original row means if i have total 2 rows those same or duplicate, so I want to delete only one row that is duplicate. Let’s go............................ Step 1: Create a student Table below Script: CREATE TABLE [Students] ( [ID] [int] NULL, [Name] [varchar] ( 50 ) NULL, [address] [varchar] ( 50 ) NULL, [contact] [varchar] ( 50 ) NULL, [email] [varchar] ( 50 ) NULL ) Step 2: insert Record that shown below: Insert Duplicate Records Step 3: Sel