"""
Table point holds the x coordinate of some points on x-axis in a plane, which are all integers.
Write a query to find the shortest distance between two points in these points.
| x   |
|-----|
| -1  |
| 0   |
| 2   |
The shortest distance is '1' obviously, which is from point '-1' to '0'. So the output is as below:
| shortest|
|---------|
| 1       |
Note: Every point is unique, which means there is no duplicates in table point.
Follow-up: What if all these points have an id and are arranged from the left most to the right most of x axis?
"""

SELECT A.x, B.x, MIN(abs(A.x - B.x)) AS shortest
FROM Leetcode613 A JOIN Leetcode613 B
ON A.x != B.x;

#NOTE: Lesser number of rows returned

SELECT A.x, B.x, MIN(abs(A.x - B.x)) AS shortest
FROM Leetcode613 A JOIN Leetcode613 B
ON A.x < B.x;


"""
Table point holds the x coordinate of some points on x-axis in a plane, which are all integers.
Write a query to find the shortest distance between two points in these points.
| x   |
|-----|
| -1  |
| 0   |
| 2   |
The shortest distance is '1' obviously, which is from point '-1' to '0'. So the output is as below:
| shortest|
|---------|
| 1       |
Note: Every point is unique, which means there is no duplicates in table point.
Follow-up: What if all these points have an id and are arranged from the left most to the right most of x axis?
"""

SELECT A.x, B.x, MIN(abs(A.x - B.x)) AS shortest
FROM Leetcode613 A JOIN Leetcode613 B
ON A.x != B.x;

#NOTE: Lesser number of rows returned

SELECT A.x, B.x, MIN(abs(A.x - B.x)) AS shortest
FROM Leetcode613 A JOIN Leetcode613 B
ON A.x < B.x;


Table point holds the x coordinate of some points on x-axis in a plane, which are all integers. Write a query to find the shortest distance between two points in these points. | x   | |-----| | -1  | | 0   | | 2   | The shortest distance is '1' obviously, which is from point '-1' to '0'. So the output is as below: | shortest| |---------| | 1       | Note: Every point is unique, which means there is no duplicates in table point. Follow-up: What if all these points have an id and are arranged from the left most to the right most of x axis? #NOTE: Lesser number of rows returned