find duplicate record and delete

WITH tblTemp as

(

SELECT ROW_NUMBER() Over(PARTITION BY Name,Department ORDER BY Name)

   As RowNumber,* FROM <table_name>

)

DELETE FROM tblTemp where RowNumber >1