Tag Archives: how to remove duplicates in a table in sql server

T-SQL : Delete duplicates in a table using Query

Following are the queries that will delete all available duplicates in a table, please refer the query below [sourcecode language=”sql” wraplines=”false”] Declare @Duplicates table (Name nvarchar(50), Age int, BookingID int) insert into @Duplicates select ‘Dinesh’,26,145 union all select ‘Latheesh’,26,142 union … Continue reading

Posted in T-SQL | Tagged , , , , | 8 Comments