SELECT GREATEST(id,val) FROM x

CREATE TABLE x(val NUMBER);
INSERT INTO x VALUES(10,1);
INSERT INTO x VALUES(20,10);
INSERT INTO x VALUES(30,100);

SELECT id,val FROM x;
SELECT id,DECODE(sign(val-100),1,'hign',0,'hign',-1,DECODE(SIGN(val-10),1,'mid',0,'mid','low'))
FROM x;

SELECT GREATEST(id,val) FROM x;

意思：

 

SELECT id,val FROM x;
SELECT id,DECODE(sign(val-100),1,'hign',0,'hign',-1,DECODE(SIGN(val-10),1,'mid',0,'mid','low'))
FROM x;
想用case，没成功，就这么凑合写了，具体就是满足高，中，低的分组，decode，sign的用法你自己看一下资料吧

SELECT GREATEST(id,val) FROM x;
greatest是只同一行中，相关列的最大值