排名语句
select *,(select count(1) +1 from tPlanApply where applyquantity> a.applyquantity ) as 名次
from tPlanApply a order by 名次
替换语句
SQL code
update tb
set 字段=replace(字段,替换后字符串,替换前字符串)
排名语句
select *,(select count(1) +1 from tPlanApply where applyquantity> a.applyquantity ) as 名次
from tPlanApply a order by 名次
替换语句
SQL code
update tb
set 字段=replace(字段,替换后字符串,替换前字符串)
转载于:https://www.cnblogs.com/delphix/archive/2009/06/16/1504026.html