注意这里的不等联结,一定要把多列括起来,不然判断的就是单列的不等
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 4 years ago