update tablename
set order=(select count(*) from tablename where PRODUCT=a.PRODUCT and city=a.city and fee<=a.fee),
percent=a.fee/(select sum(fee) from tablename where PRODUCT=a.PRODUCT and city=a.city)
from tablename a
set order=(select count(*) from tablename where PRODUCT=a.PRODUCT and city=a.city and fee<=a.fee),
percent=a.fee/(select sum(fee) from tablename where PRODUCT=a.PRODUCT and city=a.city)
from tablename a
update tablename
set [order]=(select count(*) from tablename where PRODUCT=a.PRODUCT and city=a.city and fee<=a.fee),
[percent]=a.fee/(select sum(fee) from tablename where PRODUCT=a.PRODUCT and city=a.city)
from tablename a
set [order]=(select count(*) from tablename where PRODUCT=a.PRODUCT and city=a.city and fee>=a.fee),
[percent]=a.fee/(select sum(fee) from tablename where PRODUCT=a.PRODUCT and city=a.city)
from tablename a
我当然是用费用排序了!
其实我的问题是这样的,字段的个数是未知的,但肯定有fee,order,percent字段,所以where后面的条件是不知道的!您明白了吗?