[MSSQL] 다중 컬럼(multi column)에서 집계함수 MIN, MAX, SUM, AVG 처리

[MSSQL] 다중 컬럼(multi column)에서 집계함수 MIN, MAX, SUM, AVG 처리

SELECT Col1, Col2, Col3, Col4, Col5, ( SELECT MIN(Col) FROM ( VALUES (Col1), (Col2), (Col3), (Col4), (Col5) ) AS v (Col) ) AS Col_최소값, ( SELECT MAX(Col) FROM ( VALUES (Col1), (Col2), (Col3), (Col4), (Col5) ) AS v (Col) ) AS Col_최대값, ( SELECT AVG(Col) FROM ( VALUES (Col1), (Col2), (Col3), (Col4), (Col5) ) AS v (Col) ) AS Col_평균, ( SELECT SUM(Col) FROM ( VALUES (Col1), (Col2), (Col3), (Col4), (Col5) ) AS v (Col) ) AS Col_합계, ( SELECT Max(Col) FROM ( VALUES (Col1), (Col2), (Col3), (Col4) ) AS v (Col) ) AS [Col_Col5를 제외한 최대값] FROM ( SELECT 20 Col1, 30 Col2, 40 Col3, 50 Col4, 60 Col5 ) AS T