不懂说的是不是这个意思select *
from 表a
where (str>=A and str<=B)
or (str>=A and a>b)
or (str<=B and a>b)
from 表a
where (str>=A and str<=B)
or (str>=A and a>b)
or (str<=B and a>b)
解决方案 »
- 一个关于统计多人去掉几个最高分和几个最低分的求平均分的问题
- oracle 如何查询某一个表的行数啊
- 在线等待一个sql,请大家帮帮忙
- DB LINK创建时的问题
- 这两段代码的区别
- 100分 问一下 这个动态sql语句怎么实现?
- 问个关于JOB的问题
- 菜鸟提问,怎么在Solaris中启动Oracle?
- 哪里有关于oracle方面的书籍下载阿?
- ORACLE装在简体中文操作系统上,为什么日文存入再读出后是问号?
- sql语句分类汇总,排序查询语句怎么实现
- tomcat启动报错,ORA-22905: cannot access rows from a non-nested table item?是什么原因?
SELECT '6001','7000' FROM dual UNION ALL
SELECT '6001','0100' FROM dual )
SELECT *
FROM TEST
WHERE 0500 BETWEEN A AND
(CASE WHEN B < A THEN B + 10000 ELSE TO_NUMBER(B) END)
OR 0500 BETWEEN (CASE WHEN B < A THEN B - 10000 ELSE TO_NUMBER(B) END) AND A
重复了,亲。。
WITH test AS(SELECT '5000' a,'6000' b FROM dual UNION ALL
SELECT '6001','7000' FROM dual UNION ALL
SELECT '6001','0100' FROM dual )
SELECT *
FROM TEST
WHERE 5500 BETWEEN A AND
(CASE WHEN B < A THEN B + 10000 ELSE TO_NUMBER(B) END)
OR 5500 BETWEEN (CASE WHEN B < A THEN 0001 ELSE TO_NUMBER(A) END) AND B