B 固定比C小么?如果不固定,两种情况都要判断,用union all代替or
SELECT D FROM A WHERE D < B AND Bunion allSELECT D FROM A WHERE D > C AND Bunion allSELECT D FROM A WHERE D > B AND B>Cunion allSELECT D FROM A WHERE D < C AND B>C
not between