WITH TMP AS (

       SELECT X = 2.0 UNION ALL

       SELECT X = 2.2 UNION ALL

       SELECT X = 3.3 UNION ALL

       SELECT X = 0.9 UNION ALL

       SELECT X = 0.8 UNION ALL

       SELECT X = 0.1 UNION ALL

       SELECT X = 0.2 UNION ALL

       SELECT X = 0.4

)

SELECT TOP 1 X FROM TMP

ORDER BY ABS(X-1)

일단 답변 감사합니다.  ^^

2.0 

2.2

2.3

2.3

 ~

 ~

 ~

 ~

 ~

 1.3

 수가 많을때는 답이 없는가요..??

^^;

소숫점이한자리는 가정하에

select x from table

order by abs( (x * 10) - 10 );