select a.*,e.*
from T_EnterDeclare a
left join
(select levelname,low,
nvl((select min(low) from t_alarmlevel t1 where t1.low>t0.low)
, 999999999) high
from t_alarmlevel t0) e
on a.alarmpoint>=e.low and a.alarmpoint<e.high
from T_EnterDeclare a
left join
(select levelname,low,
nvl((select min(low) from t_alarmlevel t1 where t1.low>t0.low)
, 999999999) high
from t_alarmlevel t0) e
on a.alarmpoint>=e.low and a.alarmpoint<e.high
解决方案 »
- 权限问题
- oracle10g imp导入到中途,退出了会怎么办。
- 提交的事务中的数据什么时候被写入数据文件
- select name from student和select name from student where name='%%' 的区别?
- 菜鸟求教:在JSP中如何在Oracle的存储过程执行时弹出提示框让用户选择,并根据用户的选择执行相应步骤
- "Hint: Comparison with NULL in 'p_test'"这个警告是怎么回事啊?
- 从oracle9i客户段登陆oracle9i服务器[用sys登陆,但不知道口令]....大家进来看看!!
- oracle9i的安装?
- 那位大哥有关于“复制服务器”的资料奉献出来
- 时间紧急,麻烦各位大侠给个建议~~~~~~~~~
- pl/sql Develpor 中怎么建job??
- 求一段ORACLE随机提取记录的语句 就是说每次刷新取到的记录集的顺序都不一样
from T_EnterDeclare a,
(select levelname,low,
nvl((select min(low) from t_alarmlevel t1 where t1.low>t0.low)
, 999999999) high
from t_alarmlevel t0) e
where a.alarmpoint>=e.low(+) and a.alarmpoint<e.high(+)