字符串排序需要转number才能排序
转number 的函数是to_number()
select * from CMF_SALES_PARAMETER c where pmsn='SALES_KM' order by c.pmpc asc
select * from CMF_SALES_PARAMETER c where pmsn='SALES_KM' order by to_number(c.pmpc) asc
字符串排序需要转number才能排序
转number 的函数是to_number()
select * from CMF_SALES_PARAMETER c where pmsn='SALES_KM' order by c.pmpc asc
select * from CMF_SALES_PARAMETER c where pmsn='SALES_KM' order by to_number(c.pmpc) asc