select 语句提示：缺失右括号

来源：百度知道 编辑：UC知道 时间：2024/06/04 01:21:34
select sysdate from dual where sysdate between (select KSSJ from hq.JK_DCSJSZ WHERE ROWNUM =1 order by kssj desc) and
(select JSSJ from hq.JK_DCSJSZ WHERE ROWNUM =1 order by kssj desc) ;

这也没缺啊。我想 查出 ，如果在我给定的时间范围内就查出现在时间，如果不在范围内就未选定行。

rownum代表的是物理地址，order by排出来的根本就不准的
所以根据你的情况要用min和max函数来判断时间的
所以你的要这么写

select sysdate from dual where sysdate between (select min(KSSJ) from JK_DCSJSZ) and
(select max(JSSJ) from JK_DCSJSZ) ;

再一个，楼上的，oracle里没有top 1这种写法

select sysdate from dual where sysdate between (select top 1 KSSJ from hq.JK_DCSJSZ WHERE ROWNUM =1 order by kssj desc) and
(select top 1 JSSJ from hq.JK_DCSJSZ WHERE ROWNUM =1 order by kssj desc) ;