select * from t1 , t2 on t1.id = t2.id order by cast(t2.param_value as decimal); 按int大小顺序排列; select * from t1 , t2 on t1.id = t2.id order by t2.param_value; 按字符顺序排列。
select * from t1 , t2 on t1.id = t2.id order by cast(t2.param_value as decimal);按int大小顺序排列;select * from t1 , t2 on t1.id = t2.id order by t2.param_value;按字符顺序排列。...