oracle中select (if filed1>filed2 then exp1 else exp2 end if) from tablename 怎么表达？

[signboy]

oracle中select (if filed1>filed2 then exp1 else exp2 end if) from tablename 怎么表达？
oracle 的联机帮助救像一泡屎!f

[sdfh]

select decode(sign(filed1-filed2),1,exp1,exp2) from tablename

[guo]

没错

[clavy]

最好这样写:
select case when field1>field2 then exp1 else exp2 end from tablename;

case when ... then ... else ... end 表达式