CREATE TABLE test (a INT,b INT ,c INT ,d INT); INSERT INTO test VALUES(1,2,3,4); INSERT INTO test VALUES(5,8,6,7); SELECT * FROM test; SELECT GREATEST(A, B, C, D) MMAX, CASE WHEN A = GREATEST(A, B, C, D) THEN 'a' WHEN B = GREATEST(A, B, C, D) THEN 'b' WHEN C = GREATEST(A, B, C, D) THEN 'c' WHEN D = GREATEST(A, B, C, D) THEN 'd' END MCOL FROM TEST; 输出: MMAX MCOL 8 b 4 d
CREATE TABLE test (a INT,b INT ,c INT ,d INT);
INSERT INTO test VALUES(1,2,3,4);
INSERT INTO test VALUES(5,8,6,7);
SELECT * FROM test;
SELECT GREATEST(A, B, C, D) MMAX,
CASE
WHEN A = GREATEST(A, B, C, D) THEN
'a'
WHEN B = GREATEST(A, B, C, D) THEN
'b'
WHEN C = GREATEST(A, B, C, D) THEN
'c'
WHEN D = GREATEST(A, B, C, D) THEN
'd'
END MCOL
FROM TEST;
输出:
MMAX MCOL
8 b
4 d