MSSQL 多字段根据范围求最大值实现语句，大家可以参考下

–>Title:生成測試數據–>Author:wufeng4552–>Date :2009-09-21 15:08:41declare T table([Col1] int,[Col2] int,[Col3] int,[Col4] int,[Col5] int,[Col6] int,[Col7] int)Insert Tselect 1,10,20,30,40,50,60 union allselect 2,60,30,45,20,52,85 union allselect 3