Delete duplicate rows from the table using row_number() - SQLServerCentral

IF EXISTS(SELECT * FROM tempdb.Information_Schema.TABLES WHERE Table_Name LIKE '#Temp%')
DROP TABLE #temp
 
CREATE TABLE #temp ([Id] int, [Name] varchar(50), [Age] int, [Sex] bit default 1)
Go
 
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(1,'James',25,default)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(1,'James',25,default)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(1,'James',25,default)
 
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(2,'Lisa',24,0)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(2,'Lisa',24,0)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(2,'Lisa',24,0)
 
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(3,'Mirsa',23,0)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(3,'Mirsa',23,0)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(3,'Mirsa',23,0)
 
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(4,'John',26,default)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(5,'Abraham',28,default)
INSERT INTO #temp ([Id] , [Name] , [Age] , [Sex] ) Values(6,'Lincoln',30,default)
 
 
DELETE T FROM
(SELECT Row_Number() Over(Partition BY [ID],[Name],[Age],[Sex] ORDER BY [ID]) AS RowNumber,* FROM #Temp)T
WHERE T.RowNumber > 1
 
 
SELECT * FROM #temp