ORDER BY TO_NUMBER(EVALUATE_YEAR),TO_NUMBER(EVALUATE_MONTH)
==
==
ORDER BY CAST(EVALUATE_YEAR as SIGNED),CAST(EVALUATE_MONTH as SIGNED)
oracle的number直接导入到mysql带小数点
ORDER BY CAST(EVALUATE_YEAR as SIGNED),CAST(EVALUATE_MONTH as SIGNED)
oracle的number直接导入到mysql带小数点