SQL查询最接近某一值的数据

最接近

SELECT * FROM tablename

WHERE ABS(column-10)=(SELECT MIN(ABS(column-10)) FROM tablename)

 

给定值之间

 

SELECT *
FROM     tablename
WHERE   PDRate = (

                 SELECT MAX(column)  
                  FROM    tablename

                  WHERE   column<= 0.00019
                  )