sql根据某一指标值排序
根据jydfz按pjlx排序
Select row_number() over(order by jydfz desc) as top,id,kfqdm,pjlx,jydfz
from jydfz
where pjlx = #{pjlx}
sql根据某一指标值排序
根据jydfz按pjlx排序
Select row_number() over(order by jydfz desc) as top,id,kfqdm,pjlx,jydfz
from jydfz
where pjlx = #{pjlx}