|
1
2
3
4
5
6
7
8
9
10
11 |
create table T(A decimal(10,1), B decimal(10,1), C decimal(10,1), D decimal(10,1), E decimal(10,1))insert T select
-21.5,-15.0,-5.0, null, nullunion all select
-5.5,-11.5,null, null, nullunion all select
-1.0,-16.5,-10.5, null, nullSELECT * FROM Tselect
*,max_value=(select
max(A) from( select
A union all select
B union all select
C union all select
D union all select
E)tmp)from
T |
原文：http://www.cnblogs.com/TivonStone/p/3593313.html