613 Shortest Distance in a Line

select min(abs(p2.x-p1.x)) shortest from point p1,
(SELECT * FROM [point] order by x) p2
where p1.x > p2.x

posted @ 2018-10-23 10:43 ffeng0312 阅读(117) 评论(0) 收藏举报