如何根据最小和最大值,生成一段连续数。 各位好, 我有一个表,tmystartnum endnum 1 7我想通过sql语句,查询到1,2,3,4,5,6,7这样的值,请问用sql语句如何实现。谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select rownumfrom tmywhere rownum>=startnum and rownum<=endnum select rownumfrom tmywhere rownum>=startnum and rownum<=endnum好像不行,我的startnum 是2009,endnum是2013,我想取出2009,2010,2011,2012,2013这样的值。非常感谢! SELECT LEVEL + startnum - 1 FROM tmyCONNECT BY LEVEL <= endnum - startnum + 1; with tmy as(select 2009 startnum,2013 endnum from dual)select startnum+rownum-1from tmyconnect by rownum<=(endnum-startnum)+1STARTNUM+ROWNUM-1----------------- 2009 2010 2011 2012 2013 --方式1:level+connect by levelSQL> select 2009+level-1 2 from dual 3 connect by level <= (2013-2009)+1; 2009+LEVEL-1------------ 2009 2010 2011 2012 2013 --方式2:rownum+connect by rownumSQL> select 2009+rownum-1 2 from dual 3 connect by rownum <= (2013-2009)+1; 2009+ROWNUM-1------------- 2009 2010 2011 2012 2013 --方式3:level+connect by rownumSQL> select 2009+level-1 2 from dual 3 connect by rownum <= (2013-2009)+1; 2009+LEVEL-1------------ 2009 2010 2011 2012 2013 --方式4:rownum+connect by levelSQL> select 2009+rownum-1 2 from dual 3 connect by level <= (2013-2009)+1; 2009+ROWNUM-1------------- 2009 2010 2011 2012 2013 oracle的存储过程 请教这种情况下这个update语句怎么写? group by 多表关联 优化 很诡异的问题,高手请进 请问数据库中身份证号码的比对的问题(急用) oracle 中update语句中如何排序呢 vc 6编译(oracle9i)proc生成的c文件,请高手帮忙,谢谢 如何启动数据库的监听程序?? 这个触发器语句如何?在开发中的问题。。请指点。。急要在线等。。 哪里有oracle7.3 server for windows版本下载? 请教sql语句 请教添加Oracle数据库的问题
from tmy
where rownum>=startnum
and rownum<=endnum
from tmy
where rownum>=startnum
and rownum<=endnum
好像不行,我的startnum 是2009,endnum是2013,我想取出2009,2010,2011,2012,2013这样的值。
非常感谢!
FROM tmy
CONNECT BY LEVEL <= endnum - startnum + 1;
with tmy as(
select 2009 startnum,2013 endnum from dual)
select startnum+rownum-1
from tmy
connect by rownum<=(endnum-startnum)+1STARTNUM+ROWNUM-1
-----------------
2009
2010
2011
2012
2013
--方式1:level+connect by level
SQL> select 2009+level-1
2 from dual
3 connect by level <= (2013-2009)+1;
2009+LEVEL-1
------------
2009
2010
2011
2012
2013
--方式2:rownum+connect by rownum
SQL> select 2009+rownum-1
2 from dual
3 connect by rownum <= (2013-2009)+1;
2009+ROWNUM-1
-------------
2009
2010
2011
2012
2013
--方式3:level+connect by rownum
SQL> select 2009+level-1
2 from dual
3 connect by rownum <= (2013-2009)+1;
2009+LEVEL-1
------------
2009
2010
2011
2012
2013
--方式4:rownum+connect by level
SQL> select 2009+rownum-1
2 from dual
3 connect by level <= (2013-2009)+1;
2009+ROWNUM-1
-------------
2009
2010
2011
2012
2013