数据库列间判断输出问题

[美丽海洋]

有表Table，表中A,B，C三列，假如A大于B输出B，假如B大于C输出B；怎么实现；

[--小F--]

select
  case when a>b then b
       when b>c then b
  end
form
  tb

[sql_sf]

case when
end

[黄_瓜]

select
  case when a>b then b
       when b>c then b
  end
from  tb

[黄_瓜]

select
  case when a>b then b
       when b>c then b
  end
from  tb

[GUOCHENGJUN]

select case when a>b then a when a>c then a when b>a then b end as cloumn
from table 

[SQL77]

晕楼主说错了假如A大于B输出B，假如B大于C输出B?????


最后是输出几例?是最大的那列?

SELECT
 CASE WHEN A>B THEN 
CASE WHEN B>C THEN A ELSE CASE WHEN C>B AND C<A THEN A ELSE C END
ELSE CASE WHEN A>C  THEN B ELSE CASE WHEN A>C AND A>B THEN A ELSE B END END
END

FROM TB

[SQL77]

SELECT
 CASE WHEN A>B THEN CASE WHEN B>C THEN A 
ELSE 
CASE WHEN C>B AND C<A THEN A ELSE C END 
END
ELSE 
CASE WHEN A>C  THEN B ELSE CASE WHEN A>C AND A>B THEN A ELSE B END END
END

FROM TB

[GUOCHENGJUN]

[Quote=引用 7 楼 sql77 的回复:]
SQL codeSELECTCASEWHEN A>BTHENCASEWHEN B>CTHEN AELSECASEWHEN C>BAND C<ATHEN AELSE CENDENDELSECASEWHEN A>CTHEN BELSECASEWHEN A>CAND A>BTHEN AELSE BENDENDENDFROM TB
[/Quote]
这是写的最全的了

[SQL77]

SELECT
 CASE WHEN A>B THEN CASE WHEN B>C THEN A 
ELSE 
CASE WHEN C>B AND C<A THEN A ELSE C END 
END
ELSE 
CASE WHEN A>C  THEN B ELSE CASE WHEN C>A AND B>C THEN B ELSE C END END
END

FROM TB

判断把自己都弄晕了

[fei694540127]

select case when a>b then b when b>c then b endfrom tb

[fei694540127]

select case when a>b then b when b>c then b endfrom tb

[美丽海洋]

这个题的意思是根据判断输出两列，处理case外有没有其他办法？