#法一
select min(dis) shortest from (select x, abs(lead(x,1,null) over(order by x)-x) dis from Point) a
mysql
ABS()函数返回X的绝对值
lead()为窗口函数,返回当前行后N行的值
LEAD(expression, N, default_value)
OVER ( PARTITION BY partition_expression ORDER BY sort_expression )
#法二
select min(abs(p1.x-p2.x)) shortest from Point p1, Point p2 where p1.x != p2.x