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