CREATE TABLE #T(EmpId INT, EmpName VARCHAR(50),Salary MONEY)
INSERT INTO #T
SELECT 123, 'andy', 10000 UNION ALL
SELECT 111, 'Maddy', 12000 UNION ALL
SELECT 121, 'Raman', 25000 UNION ALL
SELECT 124, 'Hemanth', 40000 UNION ALL
SELECT 133, 'krishna', 50000 UNION ALL
SELECT 122, 'andy', 20000 UNION ALL
SELECT 134, 'Raman', 60000 UNION ALL
SELECT 143, 'Maddy', 30000

SELECT SUM(Salary),EmpName FROM #T GROUP BY EmpName

DROP TABLE #T