bomlevel 为字符串,有的有两个小数点或更多 通过order by bomlevel 结果如下图.
当中1.10和1.11排到前面去了,应该排到1.9后面才对. 看不到图。。。。。。。。 SQL code: order by cast(bomlevel as dec(18,2))
图片如下
错了，试试
SQL code: order by len(bomlevel),bomlevel
SQL code: if object_id('[tb]') is not null drop table [tb] go create table [tb]([bomlevel] varchar(10)) insert [tb] select 1.10 union all select 1.11 union all select 1.9
select * from [tb] order by len(bomlevel),bomlevel
