排名语句select *,(select count(1) +1 from tPlanApply where applyquantity> a.applyquantity ) as 名次 from tPlanApply a order by 名次
替换语句
SQL code
update tbset 字段=replace(字段,替换后字符串,替换前字符串)