table_ X表中有ABC三列,用SQL语句实现:当A列大于B列时选择A列否则选择B列,当B列大于C列时选择B列否则选择C列
selectcase when A>B then A else B endcase when B>C then B else C endfrom table_ X