# Question

Formatted question description: https://leetcode.ca/all/612.html

 612. Shortest Distance in a Plane

Table point_2d holds the coordinates (x,y) of some unique points (more than two) in a plane.

Write a query to find the shortest distance between these points rounded to 2 decimals.

| x  | y  |
|----|----|
| -1 | -1 |
| 0  | 0  |
| -1 | -2 |

The shortest distance is 1.00 from point (-1,-1) to (-1,2). So the output should be:

| shortest |
|----------|
| 1.00     |

Note: The longest distance among all the points are less than 10000.



# Algorithm

1. CROSS JOIN finds the distance between the current point and each point;
2. Exclude self-connected records (distance is 0);
3. Take min, take two decimal places

SQL