刚接触asp,关于记录的排序有些疑问,大家给点帮助!

如何使用经过多次运算后的结果进行排序?

我写 "ORDER BY Final(经过最后的运算结果)"
提示说参数不足.

例如
有记录 j1,j2,j3 k1,k2,k3

a=j1+j2+j3

b=k1+k2+k3

c=a+b
.....

如果实现以c(最终结果)的排列?

何如取出排列序号?

看代码

SELECT (0+px1+px2+px3+px4+px5+px6+px7+px8+px9+px10+px11+px12+px13+15) as A1, ((cj1_wy1*cj1_wy1time+cj1_zy3*cj1_zy3time+cj1_gll*cj1_glltime+cj1_mg*cj1_mgtime+cj1_hj*cj1_hjtime+cj1_cz*cj1_cztime+cj1_tj*cj1_tjtime+cj2_dl*cj2_dltime+cj2_zy4*cj2_zy4time+cj2_wy2*cj2_wy2time+cj2_ty3*cj2_ty3time+cj2_kj*cj2_kjtime+cj2_hb*cj2_hbtime+cj2_java*cj2_javatime+cj2_gm*cj2_gmtime)/(0+cj1_wy1time+cj1_zy3time+cj1_glltime+cj1_mgtime+cj1_hjtime+cj1_cztime+cj1_tjtime+cj2_dltime+cj2_zy4time+cj2_wy2time+cj2_ty3time+cj2_kjtime+cj2_hbtime+cj2_javatime+cj2_gmtime)*0.95) as B1, (cj2_ty3*0.7) as C1, ad_pxA2A3, ad_xyB2B3, ad_wtC2C3, Id, uName, uNum, uMajor, uClass, bzjdren, (ad_pxA2A3/(select max(ad_pxA2A3) from tblUser)) as A5, (ad_xyB2B3/(select max(ad_xyB2B3) from tblUser)) as B5, (ad_wtC2C3/(select max(ad_wtC2C3) from tblUser)) as C5, ((0+A1+A5*15)*0.3) as A, ((0+B1+B5*5)*0.6) as B, ((0+C1+C5*30)*0.1) as C, (0+A+B+C) as Total
FROM tblUser
ORDER BY ?????????

(救命啊!晕死啦!)



目标是算出Total,然后按照total排列,并且得出每个记录的序号,例如total最大的为001, totol第二的为002 ....

晕~~ 头都大了,算了,帮你不到,太乱了,眼不好
要不然把你的代码和数据文件一起传上来,让大家一起来帮你改一下,有没有更好的方法?

先建立相关视图，再来进行查询排序

那些是具体的参数

我就想知道方法是怎样的.

ORDER BY ???

是用运算式吗? 为什么直接写最后结果不行的? 例如 ORDER BY Total

用式子怎么来?

刚学,不懂得用视图.....还没接触过....555 各位高手帮忙下啊!


如何实现最后结果的排列? 又怎么得到各个记录的排列号?