直线上最短距离
问题:X轴上的坐标,计算出坐标之间距离最小的值
思路: 距离=abs() 最短 = MIN()
SQL:
select min(abs(a.x - b.x)) as shortest
from point a
join point b
on a.x != b.x
问题:X轴上的坐标,计算出坐标之间距离最小的值
思路: 距离=abs() 最短 = MIN()
SQL:
select min(abs(a.x - b.x)) as shortest
from point a
join point b
on a.x != b.x