Declare @x as float
set @x = 0.35
select case @x when 0.35 then '=' else (case (@x-0.35) -abs(@x-0.35) when 0 then '>' else '<' end) end as xxx
SQL比较大小。
最新推荐文章于 2020-12-09 10:01:20 发布
Declare @x as float
set @x = 0.35
select case @x when 0.35 then '=' else (case (@x-0.35) -abs(@x-0.35) when 0 then '>' else '<' end) end as xxx