这样?
select * from nt_p2p_hour_traffic
order by BtNum1,GnutellaNum1,TEdonkeyNum1,UEdonkeyNum1,BaiduNum1
select * from nt_p2p_hour_traffic
order by BtNum1,GnutellaNum1,TEdonkeyNum1,UEdonkeyNum1,BaiduNum1
调试欢乐多
select * from nt_p2p_hour_traffic
order by BtNum1 desc,GnutellaNum1 desc,TEdonkeyNum1 desc,UEdonkeyNum1 desc,BaiduNum1 desc
-----------------
对于一条记录,BtNum1是最大的,而其它的未必是最大,你不会是想把记录都拆开来排吧
... 2 8 5 21 2
... 3 6 11 2 7
... 6 7 9 12 9
... 8 6 4 9 2
... 9 3 4 2 24
你要排成这样?你只要取这几个字段吗?如果还有其它字段的话,这些值怎么和其它字段对应?
... BtNum1 GnutellaNum1 TEdonkeyNum1 UEdonkeyNum1 BaiduNum1
... 9 8 11 21 24
... 8 7 9 12 7
... 6 6 5 9 9
... 3 6 4 2 2
... 2 3 4 2 2
select t1.BtNum1,t2.GnutellaNum1,t3.TEdonkeyNum1,t4.UEdonkeyNum1,t5.BaiduNum1
from
(select BtNum1,row_number(order by BtNum1 desc) rn from nt_p2p_hour_traffic) t1,
(select GnutellaNum1,row_number(order by GnutellaNum1 desc) rn from nt_p2p_hour_traffic) t2,
(select TEdonkeyNum1,row_number(order by TEdonkeyNum1 desc) rn from nt_p2p_hour_traffic) t3,
(select UEdonkeyNum1,row_number(order by UEdonkeyNum1 desc) rn from nt_p2p_hour_traffic) t4,
(select BaiduNum1,row_number(order by BaiduNum1 desc) rn from nt_p2p_hour_traffic) t5
where t1.rn = t2.rn and t2.rn = t3.rn and t3.rn = t4.rn and t4.rn = t5.rn
order by t1.rn