对于int
order by t.type
改为
order by cast(t.type as integer)
对于double
改为
order by CONVERT(t.type,DECIMAL)
或
order by (t.type+0)
对于int
order by t.type
改为
order by cast(t.type as integer)
对于double
改为
order by CONVERT(t.type,DECIMAL)
或
order by (t.type+0)