[Quote=引用 5 楼 j45kp 的回复:]
select
CASE WHEN 吨位=2.0 THEN 500
CASE WHEN 吨位=2.01 THEN 600
CASE WHEN 吨位=3.0 THEN 600
CASE WHEN 吨位=3.01 THEN 800
CASE WHEN 吨位=4.0 THEN 800
CASE WHEN 吨位=4.01 THEN 1000
ELSE 吨位='' END
select
CASE WHEN 吨位=2.0 THEN 500
CASE WHEN 吨位=2.01 THEN 600
CASE WHEN 吨位=3.0 THEN 600
CASE WHEN 吨位=3.01 THEN 800
CASE WHEN 吨位=4.0 THEN 800
CASE WHEN 吨位=4.01 THEN 1000
ELSE 吨位='' END