> For the complete documentation index, see [llms.txt](https://851958789.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://851958789.gitbook.io/notes/0613_shortest_distance_in_a_line/slt.md).

# 思路1

min + abs + 自联结

```sql
SELECT MIN(ABS(p1.x - p2.x)) AS shortest
FROM point p1 JOIN point p2
ON p1.x != p2.x;
```