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比较大小。
最新推荐文章于 2023-01-09 15:41:38 发布
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