思路1 JOIN计算每两点之间的距离
SELECT ROUND(
MIN(SQRT(ABS(p2.y-p1.y)*ABS(p2.y-p1.y) + ABS(p2.x-p1.x)*ABS(p2.x-p1.x)))
, 2)
AS shortest
FROM point_2d p1 JOIN point_2d p2
ON (p1.x, p1.y)!=(p2.x, p2.y);Last updated
SELECT ROUND(
MIN(SQRT(ABS(p2.y-p1.y)*ABS(p2.y-p1.y) + ABS(p2.x-p1.x)*ABS(p2.x-p1.x)))
, 2)
AS shortest
FROM point_2d p1 JOIN point_2d p2
ON (p1.x, p1.y)!=(p2.x, p2.y);Last updated