有没有一种方法可以从数据库中返回最接近给定值的数据？

SELECT * FROM table_name ORDER BY ABS(column_name - given_value) LIMIT 1;

SELECT * FROM table_name WHERE ABS(column_name - given_value) = (SELECT MIN(ABS(column_name - given_value)) FROM table_name);

CREATE FUNCTION find_closest_value(given_value NUMBER) RETURN NUMBER IS
  closest_value NUMBER;
BEGIN
  SELECT column_name INTO closest_value
  FROM table_name
  ORDER BY ABS(column_name - given_value)
  FETCH FIRST 1 ROWS ONLY;
  
  RETURN closest_value;
END;

SELECT find_closest_value(given_value) FROM dual;