SQL was good but too long

Do One thing

• Select ID, NAME, SALARY into #TableName from TableName Group by ID, NAME, SALARY
• Delete From TABLENAME
• INSERT INTO TABLENAME SELECT * FROM #TABLENAME

This is 3...