Delete Duplicate Records from Table SQL Server

In this example we show you how to delete Dupllicate records from one line query easily.The table must have identity column(Primary key) which will be used to identify the duplicate records.
In example table has Userid as Identity Column and Columns which have duplicate data are name, email, PhoneNumber.
We also show usage of Group by Clause, Max Aggregate fucntion.

Delete from TblCustomers Where UserId not in
(
Select Max(Userid)  from TblCustomers
Group by name, email, PhoneNumber )

Related Alrticles

• Download sql-introduction
• Download introduction
• Download get-columns-of-a-table-sql-server
• Download convert-float-value-to-varchar-type-in-ms-sql-server
• Download sql-server-datatypes
• Download set-nocount-on-improves-sql-server-stored-procedure-performance-high
• Download how-attackers-make-sql-injection-attack-what-script-they-used-for-sql-injection
• Download how-to-make-or-use-cursor-in-sql-server
• Download count-duplicate-records-from-table-in-sql-server
• Download delete-duplicate-records-from-table-sql-server
• Download quick-fix-to-prevent-sql-injection-attach-sql-server-Asp-Net-asp
• Download how-to-make-and-use-temporary-tables-in-sql-server
• Download stored-procedure-to-make-listing-and-search-between-to-and-from-date-or-start-date-end-date
• Download use-of-begin-commit-transaction-rollback-in-a-stored-procedure-sql-server
• Download sql-injection-attack-if-you-see-in-page-view-source-http-116jurist-ru
• Download replacing-all-text-within-brackets-or-any-other-special-character-by-ms-sql-query
• Download how-to-update-data-as-first-letter-upper-case-ms-sql-query
• Download rename-a-column-name-or-table-name-stored-procedure-name-in-ms-sql-server
• Download update-existing-column-datatype-in-ms-sql-server-database-without-losing-data
• Download compare-null-values-in-ms-sql-server