orcale 查询两端区间是否存在重叠情况

查询表中区间[START_MILEAGE_NUM,END_MILEAGE_NUM]与区间[0.000,1.999]是否存在重叠情况

 SELECT *
       FROM ORG_BOUNDARY T    WHERE greatest(0.000,T.START_MILEAGE_NUM)<least( 1.999, T.END_MILEAGE_NUM)

算法思路来源于：区间重叠算法

orcale是万能的！