如何根据最小和最大值,生成一段连续数。 各位好, 我有一个表,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的配置文件 用eclipse编写的jsp连接oracle总是出错 Oracle去掉重复结果只要一条(如图) triger的rowid问题 imp和exp都很慢,求教 存储过程的问题请教-急 搜索结果如何按指定的顺序显示 判断表在oracle数据库中是否存在? 如何进行对包含long类型的表的查询 oracle在存储过程中建临时表怎么做?在线等待,50分相送,解决马上就给! 请教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