这是做到这一点的一种方法。首先按前面
.的数字排序，然后按后面的数字排序
.
select version_number from mytable order by substr(version_number, 1, instr(version_number,'.')-1) desc ,length(substr(version_number, instr(version_number,'.')+1)) desc ,substr(version_number, instr(version_number,'.')+1) desc
