How to Remove Duplicate Rows from a Table ?

In MS-SQL SERVER If we want to remove Duplicate Data from a Table this process will be done.

--FOR CREATING TABLE USE THIS QUERY

CREATE TABLE Duplicate(
ID INT,
FNAME VARCHAR(10),
MNAME VARCHAR(10)
)

--FOR INSERT VALUES IN CREATED TABLE USE THIS QUERY

INSERT INTO Duplicate VALUES(1, 'AAA','CCC')
INSERT INTO Duplicate VALUES(2, 'BBB','DDD')
INSERT INTO Duplicate VALUES(1, 'AAA','CCC')
INSERT INTO Duplicate VALUES(2, 'BBB','DDD')
INSERT INTO Duplicate VALUES(1, 'AAA','CCC')
INSERT INTO Duplicate VALUES(2, 'BBB','DDD')
INSERT INTO Duplicate VALUES(3, 'BCB','DGD')

--FOR DISPLAY ALL RECORDS USE THIS QUERY

SELECT * FROM Duplicate

--FOR SELECT DUPLICATE DATA USE THIS QUERY

WITH CTE as(
SELECT ROW_NUMBER() OVER(PARTITION BY ID, FName, MName ORDER BY (SELECT 1)) AS RowID,
*
FROM Duplicate
)
SELECT ID, FName, MName
FROM CTE
WHERE RowID > 1

--FOR DELETE DUPLICATE DATE USE THIS QUERY

WITH CTE as(
SELECT ROW_NUMBER() OVER(PARTITION BY ID, FName, Mname ORDER BY (SELECT 1)) AS RowID,
*
FROM Duplicate
)
DELETE FROM CTE WHERE RowID > 1