请问,我有一个字符串字段(toc),里面全是数字,希望它按照数字排序,sql语句这样写的
select CAST(toc AS NUMERIC) from tt order by toc
但是出错,弹出field in orde by must result set
请问正确的sql应该怎样写
select CAST(toc AS NUMERIC) from tt order by toc
但是出错,弹出field in orde by must result set
请问正确的sql应该怎样写
FROM tt
ORDER BY Atoc