34,594
社区成员
发帖
与我相关
我的任务
分享
create table #shoes
(
feet int,
size char(5)
)
insert into #shoes
select 10,'A' union all
select 11,'B' union all
select 12,'C' union all
select 13,'D'
TRUNCATE TABLE #shoes
declare @feet NUMERIC(4,2)
set @feet=12.8
select TOP 1
*
from #shoes
order by ABS(@feet-feet)