MySQL查询查询最近的最大值 - MySQL query to search for closest highest number

MySQL query to search for closest highest number

本文关键字：查询最大值最近 MySQL | 更新日期: 2023-09-27

我有一个表

+------------+------------+--------------+---------------+
|    lbs     |     tx     |      ca      |       ny      |
+------------+------------+--------------+---------------+
|     1      |     20     |      30      |       40      |
+------------+------------+--------------+---------------+
|     2      |     25     |      35      |       45      |
+------------+------------+--------------+---------------+
|     3      |     30     |      40      |       50      |
+------------+------------+--------------+---------------+

我想MySQL查询得到最接近的基于两个变量的最高数字。就像

SELECT * FROM table WHERE state = '$state' AND lbs = '$lbs' NEAREST HIGHEST

输入1.3磅选择2磅

这可能吗?

非常简单:

SELECT * FROM table WHERE state = '$state' AND lbs >= '$lbs' LIMIT 1