请问一下这SQL怎么写?
table
UserName Total TotalTime
a1 15 530
u2 18 600
u3 20 520


现在要的结果是: TotalTime除以Total ,然后以得的值来从小到大排列..
排后结果是这样的:
table
UserName Total TotalTime
u3 20 520
u2 18 600
a1 15 530



[解决办法]
select * from [table]
order by TotalTime/Total
[解决办法]
select * from tablename order by totaltime/total
[解决办法]
select *
from 表名
order by TotalTime/Total