mysql - 获取最短距离的记录

Question

我试图通过下面的查询获取最小距离的记录，但我没有得到任何返回。正在执行查询，但结果为空。如何获得最短距离的记录？

查询:

SELECT mac, stop_name, stop_distance, speed 
FROM behaviour 
WHERE stop_distance = (SELECT MIN(stop_distance) 
                       FROM behaviour)
AND mac = '10:A5:D0:06:C6:E9' 
AND stop_name = 'Stadthalle'
LIMIT 1

屏幕截图:

Answer 1

您不需要返回最小距离的子查询，只需在查询中添加 Order by 即可你会得到你的结果

  SELECT mac, stop_name, stop_distance, speed 
    FROM behaviour 
    WHERE mac = '10:A5:D0:06:C6:E9' 
          AND stop_name = 'Stadthalle'
    ORDER By stop_distance 
    LIMIT 1