思路1
min + abs + 自联结
SELECT MIN(ABS(p1.x - p2.x)) AS shortest
FROM point p1 JOIN point p2
ON p1.x != p2.x;
Last updated
Was this helpful?
min + abs + 自联结
SELECT MIN(ABS(p1.x - p2.x)) AS shortest
FROM point p1 JOIN point p2
ON p1.x != p2.x;
Last updated
Was this helpful?