Tutorial - How to Identify and Remove Duplicates Using SQL

This is a quick video showing how to identify and delete duplicate records using a SQL Query and Common Table Expression (CTE).

Here is the table creation code:
CREATE TABLE DupeTest
(
[ID] INT IDENTITY,
[FirstName] Varchar(50),
[LastName] Varchar(50),
[Country] Varchar(50),
)
GO
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('Bob', 'Smith', 'America')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('Mike', 'Jones', 'America')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('John', 'Doe', 'Australia')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('John', 'Albert', 'Australia')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('John', 'Albert', 'Australia')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('Jane', 'Anderson', 'UK')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('Jane', 'Anderson', 'UK')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('Jane', 'Parker', 'UK')
INSERT INTO DupeTest([FirstName], [LastName], [Country])
VALUES ('Bob', 'Smith', 'Canada')
GO