612. Shortest Distance in a Plane

# Write your MySQL query statement below
SELECT ROUND(MIN(SQRT(POW(p1.x-p2.x,2)+POW(p1.y-p2.y,2))),2) AS shortest
FROM point_2d p1
LEFT JOIN point_2d p2
ON !(P1.x=P2.x AND p1.y=p2.y)
;

posted @ 2018-12-18 03:46  yuesi  阅读(188)  评论(0编辑  收藏  举报