关于金银牌排序的问题，请教高手~~~~~~跪谢

Question

select * from A order by list1 desc,list2 desc,list3 desc

Answer 1

select * from 表 order by list1 desc,list2 desc,list3 desc

Answer 2

declare @tb table(name char(10),list1 int,list2 int,list3 int)
insert @tb
select 'a',           2,          5,          9 union all
select 'b',           3,          1,          5 union all
select 'c',           2,          7,          0 union all
select 'd',           2,          5,          10
select * from @tb order by list1 desc,list2 desc,list3 desc
/*
测试结果
name       list1       list2       list3       
---------- ----------- ----------- ----------- 
b          3           1           5
c          2           7           0
d          2           5           10
a          2           5           9
*/