最接近
SELECT * FROM tablename
WHERE ABS(column-10)=(SELECT MIN(ABS(column-10)) FROM tablename)
给定值之间
SELECT *
FROM tablename
WHERE PDRate = (
FROM tablename
WHERE PDRate = (
SELECT MAX(column)
FROM tablename
FROM tablename
WHERE column<= 0.00019
)
)