求一个sql语句，平均值排序的

[lys1978900]

表内有字段 a,b,c,d,e　　要计算这几个字段的平均值，并且用平均值排序，平均值降序排序

[「已注销」]

select avg(a),avg(b),avg(c),avg(d),avg(e) from table1 order by 1 desc,2 desc,3 desc,4 desc,5 desc

[chuifengde]

select * from [Table] 
order by (isnull(a,0)+isnull(b,0)+isnull(c,0)+isnull(d,0)+isnull(e,0))/5.0 desc

[liangCK]

select * from [Table] 
order by (isnull(a,0)+isnull(b,0)+isnull(c,0)+isnull(d,0)+isnull(e,0))/5.0 desc