select case when num1< num2 and num1<num3 then num1 when num2< num1 and num2<num3 then num2 when num3< num2 and num3<num1 then num3 end as num1, case when (num1< num2 and num1>num3) or (num1< num3 and num1>num2) then num1 when (num2< num1 and num2>num3) or (num2< num3 and num2>num1) then num2 when (num3< num1 and num3>num2) or (num3< num2 and num3>num1) then num3 end as num2, case when num2< num1 and num3<num1 then num1 when num1< num2 and num3<num2 then num2 when num1< num3 and num2<num3 then num3 end as num3 from 表
select case when num1< num2 and num1<num3 then num1
when num2< num1 and num2<num3 then num2
when num3< num2 and num3<num1 then num3 end as num1,
case when (num1< num2 and num1>num3) or (num1< num3 and num1>num2) then num1
when (num2< num1 and num2>num3) or (num2< num3 and num2>num1) then num2
when (num3< num1 and num3>num2) or (num3< num2 and num3>num1) then num3 end as num2,
case when num2< num1 and num3<num1 then num1
when num1< num2 and num3<num2 then num2
when num1< num3 and num2<num3 then num3 end as num3 from 表