sqlite closes value code example

Example: sqlite closes value

SELECT * FROM table
ORDER BY ABS(value_to_compare - column.field)