Hi iammann,
Please refer below query.
SQL
DECLARE @testdemo AS TABLE(id int, [1] int ,[2] int, [3] int ,[4] int)
INSERT INTO @testdemo VALUES(1,21,31,43,13)
INSERT INTO @testdemo VALUES(2,12,22,25,23)
INSERT INTO @testdemo VALUES(3,51,44,24,55)
INSERT INTO @testdemo VALUES(4,10,04,30,85)
SELECT SUM(T1.[1])[1],SUM(T2.[2])[2],SUM(T3.[3])[3]
FROM (SELECT TOP 3 ROW_NUMBER() OVER (ORDER BY ([1]) DESC)row,[1] FROM @testdemo) AS T1
INNER JOIN (SELECT TOP 3 ROW_NUMBER() OVER (ORDER BY ([2]) DESC)row,[2] FROM @testdemo ) AS T2
ON T1.row = T2.row
INNER JOIN (SELECT TOP 3 ROW_NUMBER() OVER (ORDER BY ([3]) DESC)row,[3] FROM @testdemo) AS T3
ON T1.row = T3.row
Output
