613. Shortest Distance in a Line

613. Shortest Distance in a Line (Easy)

SQL Schema

Solution 1.

# OJ: https://leetcode.com/problems/shortest-distance-in-a-line/
# Author: github.com/lzl124631x
SELECT
    MIN(ABS(p1.x - p2.x)) AS shortest
FROM
    point p1
        JOIN
    point p2 ON p1.x != p2.x