请问下,谁知道我这句SQL语句的问题在哪吗.我在ORACLE上执行就出现ORA-00933: SQL command not properly ended,
谁能帮我纠正下错在哪里吗.
谢谢大家了.比较急select * from (select calling_range_id,range_type_id,region_info_id,switch_info_id,calling_begin,calling_end,description from calling_range
where region_info_id='1' and switch_info_id='244' order by region_info_id,range_type_id) as callingRange_tbl limit 0 , 20错误:ORA-00933: SQL command not properly ended
谁能帮我纠正下错在哪里吗.
谢谢大家了.比较急select * from (select calling_range_id,range_type_id,region_info_id,switch_info_id,calling_begin,calling_end,description from calling_range
where region_info_id='1' and switch_info_id='244' order by region_info_id,range_type_id) as callingRange_tbl limit 0 , 20错误:ORA-00933: SQL command not properly ended
解决方案 »
- 求一句sql
- 大牛们出来帮看看,关于四舍五入精度问题。。。小弟现在没分,给的少了点。帮帮忙啊
- 用pl/sql往oracle中插入sql数据怎么停止了那
- toad 7.4,oracle 10G,load procedure 出错
- 请教卸载oracle问题
- 怎么定位到倒数第二条记录的数据?
- C#中调用存储过程遇到ORA-12571: TNS:packet writer failure错误
- 怎样在oracle的存储过程中创建临时表?
- 在hpunix11上装oracle817,设置DISPLAY的问题。
- 急!!请高手指教!关于如何锁与解锁
- 为啥检索不到数据?
- form二次开发为何关闭窗口时,提示是否要保存
where region_info_id='1' and switch_info_id='244' order by region_info_id,range_type_id) as callingRange_tbl where rn>0 and rn<=20
select t.*
from (
select row_number() over(order by a.CreateTime DESC) rn,
a.*
from P010B001.V_IB_RECOGNIZE_INFO a
where CreateTime >= to_date('2009-1-1', 'yyyy-MM-dd')
and CreateTime < to_date('2010-1-1', 'yyyy-MM-dd')
) t
where t.rn > 1
and t.rn <= 20;
select calling_range_id,range_type_id,region_info_id,switch_info_id,calling_begin,calling_end,description,rownum rn from calling_range
是可以查询到大量记录的.谢谢你再帮我看一下.