FIND / DELETE DUPLICATE ROWS

WITH CTE AS (
SELECT *, RN=ROW_NUMBER() OVER ( PARTITION BY NAME,AGE ORDER BY NAME,AGE ) FROM T1
)
SELECT * FROM CTE

WITH CTE AS (
SELECT *, RN=ROW_NUMBER() OVER ( PARTITION BY ALL_COLUMNS ORDER BY ALL_COLUMNS ) FROM T1
)
SELECT * FROM CTE